On PHPEverywhere this morning, there's a new posting that I think all of us can sympathize with when it comes to working with databases. Tuning your queries and optimizing your PHP is just the first step. Read on to see what else he suggets.

In a typical web application, most of the time is spent querying the database, formatting the results and spitting the html back to the browser. This also means one of the biggest speed bottlenecks are your SQL queries. As our clients use a wide range of databases, I felt that a similar tuning tool that works across multiple databases would be useful. And to my surprise, popular tools such as PgAdmin, PHPMyAdmin and the like do not have equivalent functionality.

Through the use of the ADOdb extension, he shows you how to take the latest version, use it in your application, and optimize anything and everything about your database calls. Thanks to this new performance monitoring ability in ADOdb, they were able to find all these problems within the first hour of using the new performance monitor. Seems to me like this one might be worth a look...