NYCPHP Meetup

NYPHP.org

[nycphp-talk] mysql concurrency redux

David Mintz dmintz at davidmintz.org
Tue Feb 24 12:57:54 EST 2004


On Tue, 24 Feb 2004, Chris Shiflett wrote:

> --- David Mintz <dmintz at davidmintz.org> wrote:
> > How is using a transaction supposed to prevent another client from
> > sneaking in an update after I compare, but before I write?
>
> Transactions are guaranteed to be atomic. So, the database makes sure
> there is no such thing as "sneaking in an update after I compare, but
> before I write."
>
> Hope that helps.

Thanks -- that's exactly why I don't understand why the test I've created
appears to show otherwise. I'm trying to figure out what I'm missing.




---
David Mintz
http://davidmintz.org/

        "Anybody else got a problem with Webistics?" -- Sopranos 24:17



More information about the talk mailing list