As i have to do an order by, on a column for a table having millions of records, I found an approcah which can do faster sort in the following way. It is like doing an Inner Join with a result set which is ordered by the interested order by column, where in such column has to be indexed, so that it…

Order by using an Inner Join not working in Linux environment of Mysql

Nagini April 23, 2015, 1:00am 2

Waiting for the reply… pls help

Topic		Replies	Views
MySql Order by on a huge joined datasets is taking too long time. Other MySQL® Questions	24	1556	May 5, 2015
Order by optimisation problems Other MySQL® Questions	7	542	December 19, 2007
Join and order performance across two tables after switching from MySql Other MySQL® Questions	3	540	July 19, 2017
ORDER BY ..LIMIT using indexes still slow Other MySQL® Questions	4	577	April 14, 2008
sort in client lang (php) instead of mysql Other MySQL® Questions	1	354	November 12, 2006