page_rows -function inefficient?

[janit]

I ended up using WP as a CMS with quite a lot of pages. I ran into problems with the generation time of wp-admin/edit-pages.php. I digged a bit deeper and found out that the performance can be enhanced by modifying wp-admin/admin-functions.php. The page_rows -function the SQL query could be optimized from

if (!$pages)
    $pages = $wpdb->get_results("SELECT * FROM $wpdb->posts WHERE post_status = 'static' ORDER BY menu_order");

to

$pages = $wpdb->get_results("SELECT * FROM $wpdb->posts WHERE post_status = 'static' AND post_parent = $parent ORDER BY menu_order");

This improved my generation time from ~8.0 seconds to ~0.4 seconds. I realize that WP is not exactly meant for this, but I think a change this small is worth to do.

[jhodgdon]

This is not so easy to fix now. As of SVN version [4984], the page_rows function is no longer doing its own SQL query. It has instead been centralized into a function called get_pages (in wp-includes/posts.php).

So a different patch is needed, if the optimization still needs to be done, perhaps passing different arguments into get_pages?

I am curious if the slowness is still a problem in more current versions or not. ??

Anyway, for now marking as needing more feedback....

[Nazgul]

No real traction for over a year, so closing it as wontfix.

If somebody has suggestions/patches/... to add, feel free to reopen.