[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:  has-patch needs-    |     Focuses:  administration, performance
  testing                       |
--------------------------------+------------------------------------------
Changes (by johnbillion):

 * keywords:   => has-patch needs-testing


Comment:

 Replying to [comment:4 lriaudel]:
 > 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]
 Right, but actual numbers are still needed to demonstrate there's an
 improvement. What improvements did you see with your testing?

 Thanks for the patch! You might want to remove the unrelated changes to
 make it clearer what's changed.

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