[wp-trac] [WordPress Trac] #61097: Filter `wp_count_posts()` query before execution to avoid slow query

[WordPress Trac]

#61097: Filter `wp_count_posts()` query before execution to avoid slow query
-------------------------------------------------+-------------------------
 Reporter:  rcorrales                            |       Owner:
                                                 |  westonruter
     Type:  enhancement                          |      Status:  closed
 Priority:  normal                               |   Milestone:  6.9
Component:  Posts, Post Types                    |     Version:  2.5
 Severity:  normal                               |  Resolution:  fixed
 Keywords:  has-patch has-unit-tests has-test-   |     Focuses:
  info commit                                    |  performance
-------------------------------------------------+-------------------------
Changes (by westonruter):

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


Comment:

 In [changeset:"60788" 60788]:
 {{{
 #!CommitTicketReference repository="" revision="60788"
 Posts, Post Types: Improve `wp_count_posts()` query performance for users
 who cannot `read_private_posts`.

 The query is refactored to use two subqueries which can leverage DB
 indexes.

 Props rcorrales, snehapatil02, sirlouen, sajjad67, pbearne, johnbillion,
 westonruter.
 Fixes #61097.
 }}}

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