[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:
Component:  Query                         |     Version:
 Severity:  minor                         |  Resolution:
 Keywords:  needs-testing has-unit-tests  |     Focuses:  performance
------------------------------------------+--------------------------
Changes (by pbearne):

 * keywords:  has-patch needs-testing has-unit-tests => needs-testing has-
     unit-tests
 * owner:  (none) => pbearne
 * status:  new => assigned


Comment:

 Hi

 I created a test to check we get a random order.

 but the code provided in the patch did not provide a random order so more
 is needed.

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