When listing child pages run out of memory

Question

I am currently having an issue with memory when my site tries to generate a tree of child pages. to my understanding query is too large (WP has 60000 pages)

following is code i am using

 ?php global $post;
      wp_list_pages( array(
      'child_of' => $post->ID, // Only pages that are children of the current page
      'depth' => 1 ,   // Only show one level of hierarchy
      'sort_order' => 'asc',
      'title_li' =>$post->post_title
    ));
    ?>

Is there any additional arguments i can add to make the query smaller or is there any better way of displaying a list of child pages?

Thank you in advance.

Answer 1

WP_Query has Pagination_Parameters like posts_per_page and offset to help you out. Just page the results to limit the query to a more reasonable number per page.

Answer 2

I can't see any wrong in your code, maybe you should check that whether you can got correct post id via $post->ID, sometimes some code before yours changed $post object cause that you can't get it and wp_list_pages() will display all pages.

Answer 3

To shorten the execution time i ended up using WP_Query as suggested by jgraup

the code to generate list of children is below

<?php global $post;
  echo '<p>'. get_the_title().'</p>'; // current post title
  $query = new WP_Query( array( 'post_type' => 'page', 'post_parent' => $post->ID,'order'   => 'ASC') ); // find all pages with parentId of current page id 
      if ( $query->have_posts() ) {
          echo '<ul>'; 
          while ( $query->have_posts() ) {//loop through results
            $query->the_post();
            echo '<li><a href='. get_page_link($post->ID) .'>' . get_the_title() . '</a></li>';//li with link to the page
          }
          echo '</ul>';
          /* Restore original Post Data */
          wp_reset_postdata();
        } else {
          // no posts found
        }


    ?>