ibinod Posted March 20, 2011 Share Posted March 20, 2011 I've a table that has over a million of records, the table has a column `cat` varchar(250) NOT NULL with index i need to execute a query in this manner SELECT `cat`, COUNT(`cat`) as total FROM `products` GROUP BY `cat` HAVING `total` > 1 ORDER BY `total` DESC LIMIT 0, 200 and it takes about 2.5 sec to execute using index, temp tbl and filesort but when i remove the order by statement it only takes about 0.05 sec to execute with only using index. can someone please explain me what i can i do to minimize the execution time for my query with having orderby Thank you very much Quote Link to comment https://forums.phpfreaks.com/topic/231167-optimising-query-with-count-group-by-and-order-by/ Share on other sites More sharing options...
The Little Guy Posted March 21, 2011 Share Posted March 21, 2011 Take a look at this article, it may help: http://www.facebook.com/note.php?note_id=206034210932 Quote Link to comment https://forums.phpfreaks.com/topic/231167-optimising-query-with-count-group-by-and-order-by/#findComment-1190409 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.