Hai,
I am having 40000 distinct Albums in one table.
To display all the 40000 Albums in sorted order.I used the following
statement
"select distinct Albums from TableName order by Albums;"
To display first 50 Albums in sorted order.I used the following statement
"select distinct Albums from TableName order by Albums limit 50 offset 0;"
To display last 50 Albums in sorted order.I used the following statement
"select distinct Albums from TableName order by Albums limit 50 offset
39950;"
I noticed that performance is much slower when we use ORDER BY.
I got the output in 3000 msecs without ORDER BY and 7500 msecs with ORDER
BY.
Is there any other method where i can store the sorted results and use that
whenever needed instead f doing order by each time.
Best Regards,
A.Sreedhar.
