[wp-trac] [WordPress Trac] #34982: New algorithm for displaying a hierarchical list of post objects in the WP_Posts_List_Table is incomplete

[WordPress Trac]

#34982: New algorithm for displaying a hierarchical list of post objects in the
WP_Posts_List_Table is incomplete
-------------------------------+--------------------------
 Reporter:  rodrigosprimo      |       Owner:  johnbillion
     Type:  enhancement        |      Status:  closed
 Priority:  normal             |   Milestone:  4.7
Component:  Posts, Post Types  |     Version:  4.2
 Severity:  normal             |  Resolution:  fixed
 Keywords:  has-patch commit   |     Focuses:  performance
-------------------------------+--------------------------
Changes (by johnbillion):

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


Comment:

 In [changeset:"38451"]:
 {{{
 #!CommitTicketReference repository="" revision="38451"
 Posts, Post Types: Introduce a missing private query var that should have
 been introduced as part of #15459.

 This private query var allows the hierarchical page query on the Pages
 listing screen to query for `wp_posts.ID, wp_posts.post_parent` instead of
 `wp_posts.*`. This introduces large memory and time savings when the site
 contains a large number of Pages. Combined with the processing time
 savings introduced in [31730] this makes the Pages listing screen
 considerably more performant.

 Fixes #34982
 Props rodrigosprimo
 }}}

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