Admin Pages - The dropdown of 'Main Page (no parent)' on QuickEdit query is slow

[activecoder]

Hi, It seems like the file "wordpress/wp-admin/includes/class-wp-posts-list-table.php", line "wp_dropdown_pages( $dropdown_args );" that used to display the QuickEdit dropdown for 'Main Page (no parent)' is triggering a SQL query on all columns of the wp_posts table for all top level pages. This cause a very slow query if the system has lots of top level pages. Should WP use a more optimize query for this dropdown list that only going to display the Page title?

The query used for the drop down is:

SELECT *
FROM wp_posts
WHERE (post_type = 'page'
AND post_status = 'publish')
ORDER BY menu_order,wp_posts.post_title ASC

[webcommsat]

This was reviewed in the weekly focus on component tickets this week. This could be an improvement if there is a contributor(s) who is able to work on this. @activecoder is this something you would like to work on and do you have any examples to help others with understanding the extent of this being an issue? Thank you for raising the question and for your first ticket in Trac.

[webcommsat]

This was reviewed in the weekly focus on component tickets this week. This could be an improvement if there is a contributor(s) who is able to work on this. @activecoder is this something you would like to work on and do you have any examples to help others with understanding the extent of this being an issue? Thank you for raising the question and for your first ticket in Trac.

[webcommsat]

Just checking in @activecoder if there is anything new you would like to add to this ticket, or if you have any more detail from a recent work through of the steps you listed above. Thanks.