The table has about 12 rows.
idint(11), Unique, auto-increment, primary
I'm doing an extended insert with an ON DUPLICATE KEY UPDATE clause. Each insert has anywhere from 300-10,000 records. The more records in the table, the longer the query takes.
With 0 rows, the query took about 5-10 seconds. After about 300,000 rows, the query was taking 50 seconds.
What would be the best way to optimize this table? Thanks in advance!