Show query information

[Brandon Jaeger]

How would I display (1) the number of queries executed and (2) the time it took those queries? I've seen it on some websites before.

Thanks in advance.

---brandon

[AndyB]

The below isn't my code. I saved it from a post here long, long, ago. At worst, it'll give you a starting point:

[code]<?php
$starttime = explode(' ', microtime());
$starttime = (float)$starttime[1] + (float)$starttime[0];

/* code, code, code... */

$status = explode('  ', mysql_stat($link));
$startquery = str_replace('Questions: ', '', $status[2]);
/* query query query... */
$status = explode('  ', mysql_stat($link));
$endquery = str_replace('Questions: ', '', $status[2]);
$totalquery = $endquery - $startquery;

/* code, code, code... */

$endtime = explode(' ', microtime());
$endtime = (float)$endtime[1] + (float)$endtime[0];
$totaltime = number_format(($endtime - $starttime), 4, '.', '');

echo "Page parsed in $totaltime secs.<br>MySQL using $totalquery queries.";
?> [/code]

[b]Original post author's note[/b]
please note that $link in this example is a link variable from the database connection, so you might have to change it to your link variable to make it work.

[Brandon Jaeger]

I don't get it.

[code]$status = explode('  ', mysql_stat($link));
$startquery = str_replace('Questions: ', '', $status[2]);
/* query query query... */
$status = explode('  ', mysql_stat($link));
$endquery = str_replace('Questions: ', '', $status[2]);
$totalquery = $endquery - $startquery;[/code]
What's are these 'Questions: ' and $status[] parts?

[AndyB]

[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]What's are these 'Questions: ' and $status[] parts?[/quote]

Check the php manual for the mysql_stat function and all will become clear.

[Brandon Jaeger]

Oh, I see now! [b][2] => Questions: 1321299[/b]

I didn't realize it was this simple! Thank you, AndyB.

---brandon