WordPress.org

Make WordPress Core

Opened 16 months ago

Closed 16 months ago

Last modified 16 months ago

#43487 closed defect (bug) (duplicate)

WordPress admin list of pages section hangs

Reported by: heroic Owned by:
Milestone: Priority: normal
Severity: normal Version: 4.9.4
Component: Posts, Post Types Keywords:
Focuses: administration, performance Cc:

Description

We recently imported 0.2 millions pages into our wordpress site, and the admin section for pages became unusable. I retraced the issue to the fact that wordpress happily makes queries at certain places which are not "limit"ed.

Here's one example in wp-admin/includes/post.php:

        if ( is_post_type_hierarchical( $post_type ) && !isset($orderby) ) {
                $query['orderby'] = 'menu_order title';
                $query['order'] = 'asc';
                $query['posts_per_page'] = -1;
                $query['posts_per_archive_page'] = -1;
                $query['fields'] = 'id=>parent';               
        }

Change History (3)

#1 @jrf
16 months ago

  • Focuses coding-standards removed

#2 @birgire
16 months ago

  • Milestone Awaiting Review deleted
  • Resolution set to duplicate
  • Status changed from new to closed

Welcome to WordPress core trac.

This seems to have been reported here #9864.

So I'm closing this one for now. You're welcome to join that ticket or reopen this one, if this is a different issue.

#3 @SergeyBiryukov
16 months ago

  • Component changed from Administration to Posts, Post Types
Note: See TracTickets for help on using tickets.