Ariel Sánchez Mora <[EMAIL PROTECTED]> wrote on 04/03/2006 09:07:34 PM:
> This table holds latest data from an app:
>
> mysql> select * from ultimas_respuestas_snmp limit 10;
> +++---
> +-+---++--+
> | id
Try creating INDEX on id column
I think that will do the trick ;)
--Praj
On Mon, 3 Apr 2006 19:07:34 -0600
Ariel Sánchez Mora <[EMAIL PROTECTED]> wrote:
> This table holds latest data from an app:
>
> mysql> select * from ultimas_respuestas_snmp limit 10;
> +++
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 mus
This table holds latest data from an app:
mysql> select * from ultimas_respuestas_snmp limit 10;
+++---+-+---++--+
| id | info_oficina | columna_donde_guardar | info_interfaz |
valorSNMP | nom