How do I test the speed of a mySQL query?

Posted by Chris on Stack Overflow See other posts from Stack Overflow or by Chris
Published on 2010-05-10T13:38:58Z Indexed on 2010/05/10 13:44 UTC
Read the original article Hit count: 162

Filed under:
|
|

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?

© Stack Overflow or respective owner

Related posts about mysql

Related posts about query