Blog by Sumana Harihareswara, Changeset founder
To Optimize Response Speed On MySQL, Follow These Instructions
Hi, reader. I wrote this in 2007 and it's now more than five years old. So it may be very out of date; the world, and I, have changed a lot since I wrote it! I'm keeping this up for historical archive purposes, but the me of today may 100% disagree with what I said then. I rarely edit posts after publishing them, but if I do, I usually leave a note in italics to mark the edit and the reason. If this post is particularly offensive or breaches someone's privacy, please contact me.
Just watched Jay Pipes's 45-minute Google TechTalk, "Performance Tuning Best Practices for MySQL". A few points I took to heart:
"Bad Coding Practices" means the SQL queries your app is submitting to the DB. Pipes encourages us to think in sets, not procedural for-loops and the like, when creating our queries.
I've just listed a few of the best tips. If you deal with MySQL for fun or profit, check out the talk.