How can I find out the time taken for a query to execute, I tried to paste the query in mysql.exe but it's too long, anyone knows how to measure it??

thanks,

N_F_S

So far i know, there is nothing to get the runtime of a query. Not by default.

I use some code

function getmicrotime(){
list($usec, $sec) = explode(" ",microtime());
return ((float)$usec + (float)$sec);
}

$_s = getmicrotime();
mysql_query(blah); //here goes your mysql-query
$mysqlruntime = getmicrotime()-$_s;


Toppi

MySQL Control Center (from MySQL.com) will return the time taken. Don't know what the limits are on query length, but I'd imagine the limit you've seen is more to do with the command line buffer than a db limitation.

Toby

thartdyke,

thanks , I forgot about what programmes can do, I have MySQL-Front and it tells me the time taken for a SQL query to execute.


N_F_S