[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 has-patch has-test-info dev-   |     Focuses:
  feedback                                       |  performance
-------------------------------------------------+-------------------------

Comment (by nikunj8866):

 == Test Report
 === Description
 This report confirms that the proposed patch resolves the issue as
 described.

 Patch tested: https://github.com/WordPress/wordpress-develop/pull/8715

 === Environment
 - WordPress: 6.8.1
 - PHP: 8.2.27
 - Server: nginx/1.26.1
 - Database: mysqli (Server: 8.0.35 / Client: mysqlnd 8.2.27)
 - Browser: Chrome 136.0.0.0
 - OS: Windows 10/11
 - Theme: Twenty Twenty-Five 1.2
 - MU Plugins: None activated
 - Plugins:
   * Test Reports 1.2.0
   * WP Query Benchmarking 1.0.0

 === Actual Results
 1.  ✅ Issue resolved with patch.

 === Additional Notes

 === Supplemental Artifacts
 Before Patch:
 https://prnt.sc/QW1dLAMzbRX5

 After Patch:
 https://prnt.sc/sCA5yG5U5Jyb

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