Re: Time needed for a SQL-statement
| From: | Ulf Wendel | Date: | Tue, 17 Apr 2001 16:33:46 +0000 |
| Subject: | Re: Time needed for a SQL-statement | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-49006@lists.php.net to get a copy of this message | ||
"B. Tenhumberg" schrieb:
> Is there a way to get the time the database needed for execution a statement?
> I use MySQL and PHP...
Hmm, how about metering the overall time required by mysql_query() using
microtime(), http://www.php.net/manual/en/function.microtime.php.
As
long as there's no network bottleneck between the database (server) and
the application (server) you should be able to use that time as an
approximate value.
Ulf
--
Neu: PEAR Menu 3 - Navigationsstrukturen dynamisch dargestellt
http://www.ulf-wendel.de/projekte/menu/tutorial.php
|
http://www.phpdoc.de