Yes it was update only 1 record at the time.
But total records need to be updated is about 19.500.000.
So I made a small program that update 1.000.000 record and that's how the
calculation came out.
If only updated 1000 records at the time, the desktop runs faster but when it
reach 1.000.000
Your last query update only one record then i cannot imagine how do you measure
this.But i have answered your question based on information provided. CPU can
be used in stricte calculations likeĀ a*b or e.g sort operations. To see simple
what do CPU in particullar database operation and if you
I don't think so.
When notebook speed limit to only 0.8GHz, process drop significantly.
Update query, something like : update tbl, set ln=-999 where id = 1
Id is primary key in tbl.
I think CPU processing was used to search for index.