Possible Faster Query

[sangprabv]

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