Query Execution Time

[gaza165]

Can someone please remind me of the code to get the time it takes for sql query to run

 

i.e

 

Query took 0.04secs to complete...

 

Thanks

 

Garry

[trq]

You meen something like this?

 

That was the first thing google found when asked about a php script timer.

[ranjuvs]

if you want php sol then it is

 

$time_start = microtime(true);

Query goes here
$time_end = microtime(true);
$time = $time_end - $time_start;

 

or Mysql way then try using explain command

 

EXPLAIN yourQuery

[gaza165]

I always thought there was an easier way to do this....

 

Im doing it on an SQL statment just to notify the user how long the query took to execute.

 

$result = mysql_query("INSERT INTO chat (nick, message) values ('$nick','$message') ");

 

Am sure it is simpler than this.

 

Thanks

 

G

[trq]

Am sure it is simpler than this.

 

It doesn't get much (in fact any) simpler.