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 it gives you and vuale... not sure though, it might be useless if the time taken to do that is equivalent as to select pulling the results out. (think it is) Sincerely, Maxim Maletsky Founder, Chief Developer PHPBeginner.com (Where PHP Begins) maxim@phpbeginner.com www.phpbeginner.com -----Original Message----- From: B. Tenhumberg [mailto:b.tenhumberg@gmx.de] Sent: Tuesday, April 17, 2001 5:44 PM To: PHP General Cc: MySQL Subject: [PHP] Time needed for a SQL-statement Hi! Is there a way to get the time the database needed for execution a statement? I use MySQL and PHP... -- Berthold Tenhumberg (live long and prosper...) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net