Tell amount of mysql queries and activity thru Cpanel?

[Dolemite50]

Hi,

I am going through and optimizing my code. I would like to get a nice "before and after" picture of how many fewer queries and general activity I have after I am done optimizing. I'm sure it could be done on the server end but is there any way for me to tell on the user end when I only have access to cpanel X?

Thanks.

[nemonoman]

No, but you could easily write a function to record this info.

I bottleneck all my mysql stuff:

I created a function:

function mysqlquery($text){return mysql_query($text);}

did a global search and replace of mysql_query to mysqlquery

Now all queries run through the bottleneck. Easy now to do:

function mysqlquery($text){
global $querycount;
$querycount++;
return mysql_query($text);
}

etc.