Because you have no indexes on that table... MySQL will open and search
within the entire table.
If you would have had an index MySQL would know how to go directly to the
row you want to update.
You are always looking for rows with:
WHERE id ="?????"
So there you have... you must add an index on the column named "id" !
Run in MySQL client:
ALTER TABLE ultimas_respuestas_snmp ADD INDEX someNameForTheInde4x(id);
It will take a while... but it will get you faster.
--
Gabriel PREDA
Senior Web Developer
