Iain Poulson focused on SQL query optimization for a recent post at Delicious Brains. He shows how to identify queries causing bottlenecks and understand the problems behind them. Iain suggests some quick fixes and other ways to improve performance.
Speaking of Delicious Brains, you can also check out a recent post that compares CLI-based local dev environments.
