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
