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

[WordPress Trac]

#18836: ORDER BY RAND() is slow
------------------------------------------+-----------------------------
 Reporter:  scribu                        |       Owner:
     Type:  enhancement                   |      Status:  new
 Priority:  normal                        |   Milestone:  Future Release
Component:  Query                         |     Version:
 Severity:  minor                         |  Resolution:
 Keywords:  needs-patch needs-unit-tests  |     Focuses:  performance
------------------------------------------+-----------------------------

Comment (by MisdaX):

 Tests with MySQL EXPLAIN shows no creation of temporary tables. The
 execution time with ~900 posts is also 2-3 times faster.

 I ran the standard phpunit tests - no additional error was found.

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