RE: [PHP-DB] timer

2002-06-11 Thread Ryan Jameson (USA)
1: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(); $re

RE: [PHP-DB] timer

2002-06-11 Thread Ryan Jameson (USA)
ution 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

RE: [PHP-DB] timer

2002-06-11 Thread Leotta, Natalie (NCI/IMS)
11, 2002 1:27 PM 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)

[PHP-DB] timer

2002-06-11 Thread Natividad Castro
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