RE: [PHP] Measuring Query Times
| From: | John W. Holmes | Date: | Wed, 22 Jan 2003 10:12:03 +0000 |
| Subject: | RE: [PHP] Measuring Query Times | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-132565@lists.php.net to get a copy of this message | ||
> 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/