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

Reply via email to