Optimize MYSQL Query with Order by

Question

I have seen mysql queries with order by runs slow.

Is there any specific way to optimize queries which use order by ?

Queries without order by run very fast but with order by its always runs slow.

if any one suggest any thing on this as general solutions.

Thank You

http://dev.mysql.com/doc/refman/5.0/en/order-by-optimization.html — Julien Hoarau, Jun 18 '10 at 09:21
@Graphain done, I am always reluctant to write so short answer with a link. — Julien Hoarau, Jun 18 '10 at 09:29

score 2 · Answer 1 · answered Jun 18 '10 at 09:27

2

You could find an exhaustive answer on Mysql Site on ORDER BY Optimization.

answered Jun 18 '10 at 09:27

Julien Hoarau

1 Answers1