[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:  closed
 Priority:  normal              |   Milestone:  6.9
Component:  Database            |     Version:  5.4.1
 Severity:  normal              |  Resolution:  fixed
 Keywords:  has-patch 2nd-      |     Focuses:  administration, performance
  opinion                       |
--------------------------------+------------------------------------------
Changes (by SergeyBiryukov):

 * status:  accepted => closed
 * resolution:   => fixed


Comment:

 In [changeset:"60717" 60717]:
 {{{
 #!CommitTicketReference repository="" revision="60717"
 Database: Add `type_status_author` index for the posts table.

 This aims to improve performance of some queries on installations with a
 large number of posts.

 Follow-up to [3678], [3690], [9290], [13576].

 Props josephscott, LucasMS, Otto42, flixos90, matt, johnjamesjacoby,
 siliconforks, mukesh27,  jonsurrell, SirLouen, SergeyBiryukov.
 Fixes #50161.
 }}}

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