RE: [PHP] Measuring Query Times
There's exactly the code you're looking for I think over on Evilwalrus - http://www.evilwalrus.com/viewcode/632.php Hope it helps, Nick -Original Message- From: Peter Janett [mailto:[EMAIL PROTECTED]] Sent: 22 January 2003 06:46 To: [EMAIL PROTECTED] Subject: [PHP] Measuring Query Times I'm trying to figure out if there is an easy way to measure how long my queries in PHP/MySQL are taking to execute. Any tips or code examples most appreciated. Thanks, Peter Janett New Media One Web Services New Upgrades Are Now Live!!! Windows 2000 accounts - Cold Fusion 5.0 and Imail 7.1 Sun Solaris (UNIX) accounts - PHP 4.1.2, mod_perl/1.25, Stronghold/3.0 (Apache/1.3.22), MySQL 3.23.43 PostgreSQL coming soon! http://www.newmediaone.net [EMAIL PROTECTED] (303)828-9882 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php This private and confidential e-mail has been sent to you by Egg. The Egg group of companies includes Egg Banking plc (registered no. 2999842), Egg Financial Products Ltd (registered no. 3319027) and Egg Investments Ltd (registered no. 3403963) which carries out investment business on behalf of Egg and is regulated by the Financial Services Authority. Registered in England and Wales. Registered offices: 1 Waterhouse Square, 138-142 Holborn, London EC1N 2NA. If you are not the intended recipient of this e-mail and have received it in error, please notify the sender by replying with 'received in error' as the subject and then delete it from your mailbox. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Measuring Query Times
On Wednesday 22 January 2003 14:45, Peter Janett wrote: I'm trying to figure out if there is an easy way to measure how long my queries in PHP/MySQL are taking to execute. Using microtime() before and after your query will give you an rough idea. Yeah, unfortunately, that's the best way right now. I really wish someone would hack the MySQL API and include a function that returns the time MySQL actually used to execute the query I wish I knew how to do it, actually. ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Measuring Query Times
I'm trying to figure out if there is an easy way to measure how long my queries in PHP/MySQL are taking to execute. Any tips or code examples most appreciated. Thanks, Peter Janett New Media One Web Services New Upgrades Are Now Live!!! Windows 2000 accounts - Cold Fusion 5.0 and Imail 7.1 Sun Solaris (UNIX) accounts - PHP 4.1.2, mod_perl/1.25, Stronghold/3.0 (Apache/1.3.22), MySQL 3.23.43 PostgreSQL coming soon! http://www.newmediaone.net [EMAIL PROTECTED] (303)828-9882 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Measuring Query Times
On Wednesday 22 January 2003 14:45, Peter Janett wrote: I'm trying to figure out if there is an easy way to measure how long my queries in PHP/MySQL are taking to execute. Using microtime() before and after your query will give you an rough idea. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* So much food; so little time! */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php