[wp-trac] [WordPress Trac] #43487: WordPress admin list of pages section hangs

[WordPress Trac]

#43487: WordPress admin list of pages section hangs
-------------------------------------------------+-------------------------
 Reporter:  heroic                               |      Owner:
     Type:  defect (bug)                         |     Status:  new
 Priority:  normal                               |  Milestone:  Awaiting
Component:  Administration                       |  Review
 Severity:  normal                               |    Version:  4.9.4
  Focuses:  administration, performance,         |   Keywords:
  coding-standards                               |
-------------------------------------------------+-------------------------
 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';
         }
 }}}

--
Ticket URL: <https://core.trac.wordpress.org/ticket/43487>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform