[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:  SergeyBiryukov
     Type:  enhancement         |      Status:  accepted
 Priority:  normal              |   Milestone:  6.9
Component:  Database            |     Version:  5.4.1
 Severity:  normal              |  Resolution:
 Keywords:  has-patch 2nd-      |     Focuses:  administration, performance
  opinion                       |
--------------------------------+------------------------------------------

Comment (by SirLouen):

 Replying to [comment:33 jonsurrell]:
 > Will you clarify what you wanted me to test? I understand those changes
 target different queries. I'm not sure if this is what you meant, but I
 tried adding the indexes introduced in the other PR and ran my benchmarks
 (against the same queries in ''this ticket''). Those indexes did not seem
 to have any significant impact.

 It seems that mukesh commented that in the WCUS there were a group of
 people that were looking into this. Since you got the testing env fresh
 with all the posts and that, I wanted to quickly see if it was worthy or
 not.

 Now that I got more time, I've gotten back more deeply into that PR and
 I'm seeing that its partially related, but not completely related. The
 problem here is that that PR aimed for an improvement of a query that is
 not even as frequent as this. So I think that we can just ignore that one,
 and focus on this.

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