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:[EMAIL PROTECTED]] Sent: Tuesday, June 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) 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
