RE: [PHP] SQL Query time?

EXPLAIN gives you the time (through processor?) of the clauses translated into WHERE (JOIN, GROUP, etc) if you use 1000 billions of functions in your query, the real time of that query will be somewhat slower, but not for EXPLAIN. microtime() is in php, so it gives you the time of when he called the module, when he received and gave you back the answer. none of them is precise for the purpose of printing on web. Bad idea. But for the database design I still prefer EXPLAIN since it is for where's, where YOU are the one to play with INDEXes and KEYs. Sincerely, Maxim Maletsky Founder, Chief Developer PHPBeginner.com (Where PHP Begins) maxim@phpbeginner.com www.phpbeginner.com -----Original Message----- From: Anuradha Ratnaweera [mailto:anuradha@bee.lk]On Behalf Of Anuradha Ratnaweera Sent: Wednesday, May 02, 2001 2:06 PM To: Maxim Maletsky Cc: 'James, Yz'; php-general@lists.php.net Subject: RE: [PHP] SQL Query time? I wonder if using microtime() gives _actual_ time spent for the query while explain gives _processor_ time. Anuradha On Thu, 26 Apr 2001, Maxim Maletsky wrote: > what about microtime() ? > > you can do it your self: > > $start = microtime(); > mysql_query()... > $stop = microtime(); > > $token = round($stop-$start, 3); > echo "Query took $token seconds"; > > I mean this is not as precise as SQL would do itself, but will work > approximately. > > > Sincerely, > > Maxim Maletsky > Founder, Chief Developer > PHPBeginner.com (Where PHP Begins) > maxim@phpbeginner.com > www.phpbeginner.com > > > > > -----Original Message----- > From: James, Yz [mailto:liljim@btconnect.com] > Sent: Thursday, April 26, 2001 5:17 AM > To: php-general@lists.php.net > Subject: [PHP] SQL Query time? > > > Hi all, > > I have seen a few pages that echo the time it's taken to execute an SQL > query, like "The results in the database were returned in 0.3 seconds." > Anyone know if there's a built in function to display this, and if there is, > what it is? My more-than-useless-ISP seems to have taken an aversion to > allowing me to surf tonight without disconnecting me. > > Thanks. > James. > > > > -- > 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 > > -- > 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 > > -- 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