Page List: Parent control query limit is too small

[wwwFrank]

Description

The block "page list" can not be used for websites with more than 100 pages.

When editing the page with the "page list" a list of pages is loaded. This list is limited to 100 elements.
Pages at the end of the hierarchy of the website are not available.

Solution 1:

Set the limit to a higher value, 500 may be good.

  if (isset($params['per_page'])) {
    $params['per_page']['maximum'] = 500;
  }

Solution 2:

We have to chose a parent-page but also pages without childs are loaded.
A smarter filter for "pages with childs" will reduce the length of the list.

Step-by-step reproduction instructions

• Website with more then 100 pages
• Edit a page
• insert page list
• configure page list
• try to chose a page at the end of the content

Screenshots, screen recording, code snippet

Environment info

WordPress 6.7.2
Theme Blocksy
Gutenberg is not installed
Language German

Please confirm that you have searched existing issues in the repo.

• Yes

Please confirm that you have tested with all plugins deactivated except Gutenberg.

• Yes

Please confirm which theme type you used for testing.

• Block
• Classic
• Hybrid (e.g. classic with theme.json)
• Not sure

[t-hamano]

Note that we can't simply fix this problem by changing the maximum value to 500. See #69676 (comment)

[peterwilsoncc]

If I recall correctly, at some point the authors dropdown did multiple simultaneous requests to get all the authors. The use of simultaneous requests reduced memory issues within PHP.

@kadamwhite I think you worked on this, do you recall the details?

[Mamaduka]

@peterwilsoncc, we can do unbound queries (-1), but the block has a note on why it uses a hardcoded max pages value.

gutenberg/packages/block-library/src/page-list/edit.js

Lines 43 to 45 in 8cfa39e

	// We only show the edit option when page count is <= MAX_PAGE_COUNT
	// Performance of Navigation Links is not good past this value.
	const MAX_PAGE_COUNT = 100;