SQL Optimization

If, like me, you often dabble in writing your own dynamic apps that are driven (at least in part) by MySQL, you might want to check out this little snippet: How not to optimize a MySQL query.

Of course, the name sounds somewhat counter-intuitive; it’s actually in response to a recent article that hit the front page of Digg on how to optimize your queries. The author of the above post notes the original poster’s flaws in the attempt, and gives some broad suggestions on rectifying them. Most significantly, he sums things up with a simple statement: “Learn SQL”. He points out that each case is unique, so there isn’t a formula to follow.

It’s brief and to the point. Two minutes or so reading, and it should get across some simple yet valuable points. If you work with SQL, I’d suggest giving it a quick read-through.

Comments

About Author