mysql -- most efficient way to batch process UPDATES
View Single Post
05-06-2008, 12:09 PM
Join Date: May 2008
Anyone have any insight or tips into this? I tried searching around, but am not getting a very definative answer on how transactions are processed with multiple queries. I know there will be 25 seperate queries fired off... however I am curious as to whether or not it sends the query with each request, or will wait for the final commit to be made. Obviously before the commit happens, the changes wont happen yet... however I think they go to some type of staging area in the table with each request? Am I way off on this one?
View Public Profile
Send a private message to drewbee
Find More Posts by drewbee