[SOLVED]Quick question about php/mysql

[Gruzin]

Hi guys,

How can I write a code for mysql query wich will determine the query time? I mean something like this:

[code]Query took 0.0005 sec - from phpmyadmin[/code]

Thanks for reading,
George

[Psycho]

There may be a built in function that I'm not aware of, but barring that you simple need to save a timestamp before and after the query and subtract.

[Jessica]

$start = time();
//Do your stuff here
$end = time();

$total = $end-$start; // number of seconds.

[Gruzin]

[quote author=jesirose link=topic=121663.msg500691#msg500691 date=1168361671]
$start = time();
//Do your stuff here
$end = time();

$total = $end-$start; // number of seconds.
[/quote]

[code]<?php
$start = time();
require ('rolex/config.php');
$sql = mysql_query("SELECT * FROM archives");
$end = time();
$total = $end-$start; // number of seconds.
echo $total;
?>[/code]
It displays 0....

Thanks for your replies,
George

[Psycho]

time() only evaluates down to whole seconds. You query is probably taking less than a second to run. Use microtime() instead for milliseconds.

[Gruzin]

Thanks! it works, but when I refresh the page it displays completely different time...


Regards,
George

[Psycho]

It's not goingto be the same every time - especially since we are talking microseconds.

[Gruzin]

Ok, thank you very much mjdamato for your help  ;)