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]
--
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]
