Time cost for an Update
Posted: Mon Oct 03, 2005 3:28 am
Hi,
I have some tables with mores than 50.000 records on each, on a MySQL database. I'm concerning about the times that I need to do some opperations.
For example I have a table with more than 50.000 records on it. I'm doing an update like this
UPDATE table SET field2=2 WHERE primy_key_field=30450
After I do some tests I observed that I need a time from this interval for each opperation
0.00020s < Execution Time < 0.00035s
The problem is that sometimes I have to do more than 10.000 updates at one time, and it takes a lot of time. It's possible to have a less execution time for an update ?
How can I reach a fastest execution time ?
I have some tables with mores than 50.000 records on each, on a MySQL database. I'm concerning about the times that I need to do some opperations.
For example I have a table with more than 50.000 records on it. I'm doing an update like this
UPDATE table SET field2=2 WHERE primy_key_field=30450
After I do some tests I observed that I need a time from this interval for each opperation
0.00020s < Execution Time < 0.00035s
The problem is that sometimes I have to do more than 10.000 updates at one time, and it takes a lot of time. It's possible to have a less execution time for an update ?
How can I reach a fastest execution time ?