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

WordPress Trac noreply at wordpress.org
Sun Apr 20 09:35:44 UTC 2025


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

 * keywords:  early changes-requested has-patch => early has-patch has-
     testing-info dev-feedback


Comment:

 Note that I have ignored the unit-tests because there are already unit-
 test for orderby rand in `::test_orderby()`

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


More information about the wp-trac mailing list