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

WordPress Trac noreply at wordpress.org
Wed Mar 26 16:11:27 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:  needs-testing has-unit-tests has-    |     Focuses:
  patch early                                    |  performance
-------------------------------------------------+-------------------------

Comment (by adamsilverstein):

 We discussed this today in the Performance bug scrub and the question came
 up: is this still true: "ORDER BY RAND() is slow" or has this issue been
 resolved already?

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


More information about the wp-trac mailing list