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

[WordPress Trac]

#18836: ORDER BY RAND() is slow
-------------------------------------------------+-------------------------
 Reporter:  scribu                               |       Owner:  pbearne
     Type:  enhancement                          |      Status:  assigned
 Priority:  normal                               |   Milestone:  Future
                                                 |  Release
Component:  Query                                |     Version:
 Severity:  minor                                |  Resolution:
 Keywords:  early has-patch has-test-info dev-   |     Focuses:
  feedback changes-requested                     |  performance
-------------------------------------------------+-------------------------
Changes (by peterwilsoncc):

 * milestone:  6.9 => Future Release


Comment:

 @SirLouen I won't have time for 6.9 so I've moved it as suggested.

 > ...I would have to re-read all the docs about this algo in Stack
 Overflow...

 Basically the same problem here, but I'd be going in completely fresh :)

 If inspirations hits at any point, I'll push to your branch as suggested.
 Thanks

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/18836#comment:39>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform