| Subject | How to improve update performance with millions records? |
|---|---|
| Author | firebird_jimmy |
| Post date | 2012-06-11T19:10:28Z |
Hi, I'm jimmy
I have a problem, please help me!
I have a table with 3,000,000 rows record, every row update 1 to 5 times in one day. The speed of update statement become slowly, about 30 records/second, but insert speed above 1000 records/second.
Is my usage be bad or not?
what should i do?
thanks!
20120610
I have a problem, please help me!
I have a table with 3,000,000 rows record, every row update 1 to 5 times in one day. The speed of update statement become slowly, about 30 records/second, but insert speed above 1000 records/second.
Is my usage be bad or not?
what should i do?
thanks!
20120610