UPDATE command is very slow

[Funkiki]

Hi

Updating 30 records in a table of 3000 records takes about 1.5 sec : I guess this is not normal !

My table is very simple : INNODB, only two fields called 'varname' VARCHAR(50) and 'value' VARCHAR(255). 'varname' is PRIMARY key.

My Request is also so simple : UPDATE mytable SET value='XXXX' WHERE varname='XXXX'

Why is it so slow ?


I had the same trouble with the INSERT command : inserting 3000 records in that table takes more than 30 seconds. But after trying the multiple INSERT, I have been able to reduce that time to some seconds. Is there some similar triks to speed up the Update request.

I'm using the 'mysql_query' command from a C++ application.

MySQL Version : - 5.0.22-community-nt