I have this query on my current application: SELECT count(sql_id) AS total, DATE_FORMAT(insertdate, '%H:%i' ) AS mydate FROM momt WHERE 1=1 AND insertdate BETWEEN DATE_ADD(NOW(), INTERVAL - 1 HOUR) AND NOW() AND (sms_type = 1 OR sms_type =2) GROUP BY mydate ORDER BY insertdate
Is there any possibilities to speed up the query? Because my data become very huge and this query seems getting slower. TIA. Willy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
