[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 jonsurrell):

 Replying to [comment:32 SirLouen]:
 >
 > Like @mukesh27 commented, there is another variant commented on in
 #15499 that can be seen in [https://github.com/WordPress/wordpress-
 develop/pull/3117 PR 3117] …
 > I have not tested it yet, but since you made the test env, could you
 also check this to see whether this is better or not? At a first glance I
 would say it should not.

 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.

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