If you have a slow web app and you suspect the database is part of the issue, then this is for you.
I gave a version of this talk last night to the DC PHP Developers Group.
I’m not pretending to be a Join-fu Drunken Query Master at this point, but I’ve had success dealing with poorly performing database-driven applications, based on research and tweaking. The slides are a slightly prettified version of notes I originally collected for myself. YMMV.
I’d love to learn about your experiences, and I think the community would also like to see whatever you can share.