[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