For The Love Of God, Use Keys!

I recently worked on an application I built some time ago. It was built before I had regard for performance or cared about how a MySQL database should be built. As such, it had no indexes.

That changed, especially when I started playing with old data that I wanted to migrate. The read time on 15 rows in a 325-row table was some 0.86 seconds (which isn’t bad but isn’t great). When indexes were applied, however, the read time went down to 0.01 seconds, an 88% decline in read time.


Saturday, December 20th, 2008 @ 4:49 pm | Comments (0) | Categories: Uncategorized, Databases
Tags: ,

Copyright © 2024 by Brandon Savage. All rights reserved.