oopsss... I should put the getmicrotime() function... sorry, here it is:
function getmicrotime(){
list($usec, $sec) = explode(" ",microtime());
return ((float)$usec + (float)$sec);
}
-----Original Message-----
From: Ryan Jameson (USA)
Sent: Tuesday, June 11, 2002 11:22 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] timer
Just set one variable $var1=time(); before you call mysql_query and then subtract it
from time(); after the query. That will be the number of seconds. If you need better
precision you can use milliseconds too:
$t1 = getmicrotime();
$result_query = mysql_query($query_prism);
echo "<hr>Execution Time: " . (getmicrotime()-$t1) . " seconds";
<>< Ryan
-----Original Message-----
From: Natividad Castro [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 11, 2002 11:27 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] timer
hi to all,
how can I set up a timer that will tell me how long a query takes to run.
for example, if I run the following query, I would like to know how long it
takes.
$query_prism = "INSERT INTO prism_rec_status(prism_rec_id) select 150bk.ID
from 150bk
WHERE PHY_ST='IN' Or PHY_ST='OR' Or PHY_ST='PA' Or
PHY_ST='IA' Or PHY_ST='MN'
Or PHY_ST='CO' Or PHY_ST='ME' Or PHY_ST='TN' Or
PHY_ST='GA'";
$result_query = mysql_query($query_prism);
Is that possible in php??
Thanks in advanced
Nato
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
