Re: [PHP] Time needed for a SQL-statement

"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 netw

RE: [PHP] Time needed for a SQL-statement

Have you tried EXPLAIN ? EXPLAIN SELECT * FROM tables WHERE this='this' AND that='that' ORDER BY this, that ; A query like this would return you some of the stats. Catch the time