Posted by Bonge Boo! on 09/04/05 14:37

I've been reading up on transaction in MYSQL and can see exactly why they
may be necessary. However I was wandering this. You only problems occur is
you have multiple threads trying to access data that have been changed by
another thread.

So they question is, for a relatively simply SQP query, maybe a select and
then an update based on the id returned by that query, how fast would that
happen? Then I can make a rough guess as to the volume of people you'd need
on the site before it was likely or possible that you might get 2 threads
accessing the same data in the time it takes for a transaction to finish...

I guess it depends on processor speed?

[Back to original message]