[wp-trac] [WordPress Trac] #62801: Improve performance of X-WP-TotalPages queries

[WordPress Trac]

#62801: Improve performance of X-WP-TotalPages queries
----------------------------------------------+---------------------------
 Reporter:  spacedmonkey                      |       Owner:  spacedmonkey
     Type:  enhancement                       |      Status:  closed
 Priority:  normal                            |   Milestone:  6.9
Component:  REST API                          |     Version:  3.7
 Severity:  normal                            |  Resolution:  fixed
 Keywords:  has-patch early needs-unit-tests  |     Focuses:  performance
----------------------------------------------+---------------------------
Changes (by peterwilsoncc):

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


Comment:

 In [changeset:"61002" 61002]:
 {{{
 #!CommitTicketReference repository="" revision="61002"
 REST API: Improve performance of `X-WP-Total`/`X-WP-TotalPages` queries.

 Improve the performance of fallback queries to determine the total number
 of objects available on various REST endpoints for out of bounds queries.

 The database queries are modified to return the minimum amount of data
 required for determining the count and bypass priming of meta a term
 caches where appropriate.

 Props adamsilverstein, joehoyle, johnbillion, jorbin, kadamwhite,
 spacedmonkey, sukhendu2002, westonruter.
 Fixes #62801.
 }}}

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