Just did a big no no with MySQL?

[Lt. Manlove]

The table had already about 2000 rows, all with an index key.

We imported 6000 more rows starting with an index of 1 000 000. The queries are now a lot slower.

Is this due to MySQL searching over 1 million indexes rather than the 8000 it should? And is there a way to fix this?

Cheers

 

[Lt. Manlove]

So it probably is or isn't the large gap from 2000 - 1000000 ?

I'm just wondering why my queries are taking a while to execute and that seems like the obvious answer.