[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:  6.9
Component:  Query                          |     Version:
 Severity:  minor                          |  Resolution:
 Keywords:  early changes-requested close  |     Focuses:  performance
-------------------------------------------+--------------------------
Changes (by SirLouen):

 * keywords:  early changes-requested => early changes-requested close


Comment:

 Adding more beef to the grill, I completely forgot the most obvious test…
 number of queries

 This is without any modifications, just bare queries like the
 [https://core.trac.wordpress.org/ticket/18836#comment:25 mentioned here]

 [[Image(https://i.imgur.com/CQdFQij.png)]]

 After all this testing, I'm starting to think that this ticket is
 completely obsolete by now.

 With all this info provided, I would add this as a candidate for `close` ⇒
 `wont-fix`

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