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) [EMAIL PROTECTED] www.phpbeginner.com -----Original Message----- From: B. Tenhumberg [mailto:[EMAIL PROTECTED]] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php