[wp-trac] [WordPress Trac] #18836: ORDER BY RAND() is slow

WordPress Trac wp-trac at lists.automattic.com
Sat Oct 1 17:03:40 UTC 2011


#18836: ORDER BY RAND() is slow
-------------------------+------------------------------
 Reporter:  scribu       |       Owner:
     Type:  enhancement  |      Status:  new
 Priority:  normal       |   Milestone:  Awaiting Review
Component:  Performance  |     Version:
 Severity:  minor        |  Resolution:
 Keywords:               |
-------------------------+------------------------------

Comment (by scribu):

 Here's a method of doing it all in a single query:

 http://explainextended.com/2009/03/01/selecting-random-rows/

 Not sure how feasible it would be for WP.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/18836#comment:1>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software


More information about the wp-trac mailing list