Time a sql query

[newbtophp]

I created a function which i can use instead of mysql_query, which would query aswell as check the time taken for the queries execution, but now was wondering if i could do some sort of if statement to determine if the execution time is higher than the average - than email it.

 

function time_query($query){
$s = microtime(true);
$results = mysql_query($query);
$e = microtime(true);
//not sure whats average...
if(round($e - $s, 3) > IS HIGHER THEN AVERAGE){
mail(....);
}
return $results;
}

[Alex]

You have the basic idea down. You would just need to store the average time taken in some way.

[waynew]

There are tools out there that can do all of this for you, just so you know.