Response times of retrieved records from a database

[adgalo]

Good day to all!

How can I create a script that displays the response times of the retrieved records from a database?

Thank you

adgalo

[bpat1434]

Huh? Response times? Like, how long the query took?

If you want to know how long the query took:

$query = "SELECT * FROM `table` ORDER BY id DESC";

$start = microtime(true); // get time of start
/**
 *  Do your mySQL query in this area
 */
$result = mysql_query($query);

$end = microtime(true); // Get ending time

$total = $end-$start;
echo 'Query took '.$total.' seconds to execute';