MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: ORDER BY RAND() taking too much time
Posted by: Yogesh Salvi
Date: May 03, 2006 02:11AM

I created compound index on (id_pr_data_feed,id) and now it is taking 5 to 6 sec [almost half time then previous]....

Thanks.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
ORDER BY RAND() taking too much time
10206
Yogesh Salvi
April 29, 2006 05:30AM
Re: ORDER BY RAND() taking too much time
3802
Sebastien Caisse
May 01, 2006 08:49AM
Re: ORDER BY RAND() taking too much time
4092
Yogesh Salvi
May 02, 2006 08:44AM
Re: ORDER BY RAND() taking too much time
3539
Björn Steinbrink
May 02, 2006 02:24PM
Re: ORDER BY RAND() taking too much time
3133
Yogesh Salvi
May 03, 2006 01:51AM
Re: ORDER BY RAND() taking too much time
2930
Yogesh Salvi
May 03, 2006 02:11AM
Re: ORDER BY RAND() taking too much time
3417
Ravenous Bugblatter Beast
August 15, 2006 05:13PM
Re: ORDER BY RAND() taking too much time
2600
Yogesh Salvi
May 11, 2006 04:25AM
Re: ORDER BY RAND() taking too much time
3816
Erin ONeill
June 08, 2006 10:38AM


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.