[wp-trac] [WordPress Trac] #50161: Slow query in WP_Posts_List_Table, no way to avoid with filters/hooks

[WordPress Trac]

#50161: Slow query in WP_Posts_List_Table, no way to avoid with filters/hooks
--------------------------------+------------------------------------------
 Reporter:  LucasMS             |       Owner:  (none)
     Type:  enhancement         |      Status:  reopened
 Priority:  normal              |   Milestone:  6.9
Component:  Posts, Post Types   |     Version:  5.4.1
 Severity:  normal              |  Resolution:
 Keywords:  has-patch 2nd-      |     Focuses:  administration, performance
  opinion                       |
--------------------------------+------------------------------------------
Changes (by johnjamesjacoby):

 * keywords:  has-patch => has-patch 2nd-opinion
 * milestone:   => 6.9


Comment:

 Replying to [comment:14 josephscott]:
 > @johnjamesjacoby where do we go from here?  I'd really like to get this
 into WP 6.9.

 Good question... I think this doable in 6.9 for what I know about the
 intended scope of this release. I'll milestone it as such right now.

 Replying to [comment:13 siliconforks]:
 > The only way I can get it to use the index is to specify the index
 explicitly:

 That's not ideal. `USE INDEX` makes sense here, but nothing in WordPress
 Core uses that variety of hint, so we'll definitely need a 2nd opinion
 before integrating it, and I'll add that keyword.

 (bbPress has 1 `FORCE INDEX` in it to address a similar MySQL optimization
 concern, inside of `_bbp_has_replies_where()`.)

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