Page name drop-downs do not scale well

[mrmist]

The page title drop-downs on options-reading and page.php seem to scale poorly in page loading times when you have a large number (around 1000) of Pages.

I need to go to bed now so haven't researched this much, but I think the options-reading bit could be improved - I think it's currently fetching all of wp_posts when it only needs the title, which is a fair bit of wasted DB and processing time.

rev 10051 and previous.

[Denis-de-Bernardy]

+1. get_pages() needs an extra fields param to pick the fields, that would default to *. And post caching should not be enforced (as is done in get_terms()) when fields is not *.

[hakre]

page.php -> edit page.

but what is options-reading?

[Denis-de-Bernardy]

Replying to hakre:

The issue is highlighted in my above comment. What happens is, WP retrieves all fields of all pages. as in, absolutely everything. It might just as well get ID, post_title, post_parent instead. This would speed things up.

In get_terms(), there is a means to grab a subset of fields only -- which disables the caching when it's used. get_pages() should probably get the same thing.

[Denis-de-Bernardy]

see also #8874

[Denis-de-Bernardy]

punting to future, pending patch

[janeforshort]

Punting due to lack of patch.

[nacin]

Duplicate of #9864.