How to show the number of queries executed for a PHP/mysql page?

[irock]

Hi, I would like to do some benchmark on my site...

Could you tell me how to show the numbe rof queries executed for a PHP/mySQL generated page?

Thanks!

[justageek]

Probably depends on how you make your database calls. I use both a database function and direct calls to the db. When using the function I just have a counter I echo out debug info including the amount of times it gets called. When not using it I just echo each database call and can count them. If you have the mcc or the new administrator and can control the usage on the system to just the one page you want you can see the amount of queries from either one.

JAG