[wp-trac] [WordPress Trac] #52999: Decrease the number of SQL queries in the pages list table

[WordPress Trac]

#52999: Decrease the number of SQL queries in the pages list table
-------------------------------------+--------------------------
 Reporter:  Chouby                   |       Owner:  (none)
     Type:  enhancement              |      Status:  new
 Priority:  normal                   |   Milestone:  5.8
Component:  Administration           |     Version:
 Severity:  normal                   |  Resolution:
 Keywords:  has-patch needs-testing  |     Focuses:  performance
-------------------------------------+--------------------------

Comment (by audrasjb):

 I ran some quick tests using query monitor and here are the results:

 {{{
 Before patch:
 - Page Generation Time: 0,9868 | 3,3% of 30s limit
 - Peak Memory Usage: 87 072 kB | 16,6% of 524 288 kB limit
 - Database Query Time: 0,0255
 - Database Queries: Total: 85
 - Object Cache: 94,4% hit rate (4 506 hits, 266 misses)
 - - - -
 After patch:
 - Page Generation Time: 0,9690 | 3,2% of 30s limit
 - Peak Memory Usage: 87 065 kB | 16,6% of 524 288 kB limit
 - Database Query Time: 0,0217
 - Database Queries: Total: 84
 - Object Cache: 94,5% hit rate (4 515 hits, 264 misses)
 }}}

 That was tested on a small website. Would be nice to get some tests on a
 bigger one.

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