MySQL Forums
Forum List  »  Performance

sorting takes more time
Posted by: Bodapati murthy
Date: March 14, 2005 12:44AM

My table contains more than 3 lakhs records.when I am sorting them it is taking more than 50 sec for sorting.Primary key of my table is a blob.For temporarily reducing the sorting time I set "max_sort_length" = 50. Can any body give me a permanent solution without reducing the max_sort_length. I want to reduce the sorting time to be less than 10sec.


Any information related to this will help me a lot.



Thanks & Regards,
B.T.S.murthy.
<bmurthy@cordys.com>

Options: ReplyQuote


Subject
Views
Written By
Posted
sorting takes more time
2798
March 14, 2005 12:44AM
1414
March 14, 2005 02:18AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.