MySQL Buckeling after a million rows?
View Single Post
05-08-2008, 12:28 PM
Join Date: May 2008
Right. That is exactly what I was thinking. The performance degrades as it approaches the millionth mark. Probobly from about 800k+. I thought that 1M rows would be childs play for a database, so it has to be something that I have setup incorrectly.
Does anyone know if it is pointless that I have unique keys and indexes for the same columns? Does creating a unique key on a column also automatically create an index, thus making the indexes I created for the already-unque-key columns pointless?
View Public Profile
Send a private message to drewbee
Find More Posts by drewbee