|
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?
Navigation:
[Reply to this message]
|