michael schurter

…create good indexes.

This should be obvious, but for some reason I was getting frustrated with MySQL for taking almost 30 seconds to query a 1 GB table that only had a worthless index on a surrogate key. With proper indexing, the same query takes less than 1/10th of a second.

This entry was posted on Friday, November 17th, 2006 at 10:20 am and is filed under Open Source, SQL, Technology. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.