May 10th, 2002, 01:39 PM
|
|
Junior Member
|
|
Join Date: May 2002
Posts: 2
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Well, for the time generation, use something like...
PHP Code:
<?php
$timeparts = explode(" ",microtime());
$starttime = $timeparts[1].substr($timeparts[0],1);
// Your script here
$endtime = $timeparts[1].substr($timeparts[0],1);
echo bcsub($endtime,$starttime,6);
?>
For the number of mysql querys, use a variables, and increse it one after every mysql query, and then print it, eg.
PHP Code:
$result = mysql_query("SELECT this FROM that");
$num_querys++;
For the mysql query time, you would have to do something like...
PHP Code:
$timeparts = explode(" ",microtime());
$sqlstart = $timeparts[1].substr($timeparts[0],1);
$result = mysql_query("SELECT this FROM that");
$sqlend = $timeparts[1].substr($timeparts[0],1);
$sql_total += bcsub($endtime,$starttime,6);
echo $sql_total;
Putting that all together...
PHP Code:
<?php
$timeparts = explode(" ",microtime());
$starttime = $timeparts[1].substr($timeparts[0],1);
$timeparts = explode(" ",microtime());
$sqlstart = $timeparts[1].substr($timeparts[0],1);
$result = mysql_query("SELECT this FROM that");
$num_querys++;
$sqlend = $timeparts[1].substr($timeparts[0],1);
$sql_total += bcsub($endtime,$starttime,6);
$sql_time = bcsub($endtime,$mysqtime,6);
$endtime = $timeparts[1].substr($timeparts[0],1);
echo 'Page generated in ' . bcsub($endtime,$starttime,6) . 'seconds with ' . $num_querys . 'queries, spending ' . $sqltime . 'doing MySQL querys and ' . $sql_time - $endtime . ' doing PHP things.';
?>
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
