Timing SQL queries

[Mark Hewitt]

I'm working on a hack for my forums and have worked out how I would like to implemented and have tested it sucessfully. However I'm worried about the efficiency of deploying it across the board on by forums, as it alters one of the core SQL queries, so even if this particular hack wasn't in use at the time it could potentially slow down the forums.

Is there some way I can quantifiably measure how long a query using the standard vs the modified SQL statement takes. So I can judge if it's worthwhile rolling it out on a larger scale.

[Admin]

Take a look at db_mysql.php from vBulletin, especially the query() method there. It does what you neeed.