List:General Discussion« Previous MessageNext Message »
From:sangprabv Date:July 10 2009 2:44am
Subject:Possible Faster Query
View as plain text  
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.


Possible Faster Querysangprabv10 Jul
  • Re: Possible Faster QueryMarcus Bointon10 Jul