[wp-trac] [WordPress Trac] #40434: Optimize SQL in Admin - In the Post/CPT List `wp-admin/edit.php` > the function get_posts()

[WordPress Trac]

#40434: Optimize SQL in Admin - In the Post/CPT List `wp-admin/edit.php` > the
function get_posts()
-------------------------+------------------------------------------
 Reporter:  lriaudel     |       Owner:
     Type:  enhancement  |      Status:  new
 Priority:  normal       |   Milestone:  Awaiting Review
Component:  Query        |     Version:  4.7.3
 Severity:  normal       |  Resolution:
 Keywords:               |     Focuses:  administration, performance
-------------------------+------------------------------------------

Comment (by lriaudel):

 Replying to [comment:3 johnbillion]:
 > It would also be great to see some before/after query timings for this
 change.

 If you want info of the difference `OR` and `IN`, here :
 [http://stackoverflow.com/questions/782915/mysql-or-vs-in-
 performance?answertab=votes#tab-top]

 And here :
 [http://stackoverflow.com/questions/3074713/in-vs-or-in-the-sql-where-
 clause]

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