Regarding: "Is there any other method where i can store the sorted results and use that whenever needed instead f doing order by each time."
You're using an index on the "Albums" column, right? If not, that will make a tremendous difference. This message has been scanned for viruses by MailControl - www.mailcontrol.com ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------