RE: [PHP-DB] timer
| From: | NCI/IMS) | Date: | Tue, 11 Jun 2002 17:20:31 +0000 |
| Subject: | RE: [PHP-DB] timer | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-19750@lists.php.net to get a copy of this message | ||
You could probably use:
$start = time();
//run query
$end = time();
and then compare start and end. I don't know how time() formats the time,
but that's probably on PHP.net.
-Natalie
-----Original Message-----
From: Natividad Castro [mailto:ncastro@cots.com]
Sent: Tuesday, June 11, 2002 1:27 PM
To: php-db@lists.php.net
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