How do I test the speed of a mySQL query?

Question

I have a select and query like below...

    $sql = "SELECT * 
        FROM notifications 
        WHERE to_id='".$userid."' 
            AND (alert_read != '1' OR user_read != '1') 
        ORDER BY alert_time DESC";
    $result = mysql_query($sql);

how do I test how long the query took to run?

Answer 1

Might want to look at this discussion:

http://stackoverflow.com/questions/1191067/how-to-test-mysql-query-speed-with-less-inconsistencies

Answer 2

If you run the query from the mysql console you, the speed will be displayed right after they query is ran.

Answer 3

use php function microtime() before and after mysql_query, and then compare results.

$time1 = (int) microtime();
$result = mysql_query($sql);
$time2 = (int) microtime();

echo ($time2 - $time1);

(if you use microtime(true) - which returns float number, you will get less acurate number)