[wp-trac] [WordPress Trac] #52626: Block editor doesn't paginate parent page results

[WordPress Trac]

#52626: Block editor doesn't paginate parent page results
--------------------------+------------------------------
 Reporter:  hobzhobz      |       Owner:  (none)
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Editor        |     Version:  5.6.2
 Severity:  major         |  Resolution:
 Keywords:                |     Focuses:  rest-api
--------------------------+------------------------------

Comment (by axdr):

 Replying to [comment:8 hobzhobz]:
 > Replying to [comment:6 axdr]:
 > > Too many records in the drop-down list will make it impossible to use
 it.
 > >
 > > No need to solve this problem by outputing the headings of all pages.
 > > Perhaps someone can solve it using the menu-order field.
 >
 > Warning: might sound condescending. But i'm trying to be extra clear
 here because this seems so hard for people to understand...
 >
 > It's already sorted by menu_order.
 > You know what happens if menu_order is 0 on all pages? Undefined
 behavior. You know what that means? It means that they come in seemingly
 random order. Do you know what that means when doing pagination? It means
 that page 1 has 100 random pages. Page 2 has 100 random pages. Did you
 know that this means that the same page can come on page 1 and page 2? Yes
 it can.
 > You need to sort on menu_order AND a secondary parameter. Something like
 ID perhaps.
 >
 > BAD: order by menu_order limit 0,100
 > GOOD: order by menu_order, ID limit 0,100
 >
 >
 >

 BAD: ORDER BY menu_order LIMIT 0,100
 GOOD: WHERE menu_order<>0 ORDER BY menu_order, post_title

 The problem is that it is GOOD only when the number of pages is more than
 critical

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/52626#comment:9>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform