I see the topic of MySQL optimization come up frequently in discussions. Understandably so, given that it doesn’t take that much data for a poorly optimized query to become the bottleneck in an otherwise well thought out process.

(more…)