Search length in MySQL

[Anon]

Hi,

Is there a way in PHP to know how long
it took MySQL to do the search? (You know, just like
google do. Example : Search took 0.08 seconds)

Thanks

[Anon]

Sure.
PHP has a function called "mircotime()"
this gives a timestamp well into the microseconds.
Do something like this:

$start_time=microtime();
// Do your sql here
$end_time=microtime();

$starttime = explode(" ",$starttime);
$endtime = explode(" ",$endtime);
print number_format((($endtime[0] + $endtime[1])-($starttime[0] + $starttime[1])),4)." seconds.";