Context Navigation

Changes between Initial Version and Version 1 of Ticket #37220, comment 1

initial	v1
3	3	The latter doesn't require `COUNT` and avoid using `OFFSET` entirely which can be even of a performance problem for large offsets.
4	4
5		To me `CursorPaginator` has the same limitation as this suggested N+1 item approach (no listing of pages, ''has next page'' can also be achieved by fetching an extra item) but with less drawback (no `OFFSET`) so I see limited benefits in maintaining a solution that only address performance concerns partially.
	5	To me `CursorPaginator` has the same limitation as this suggested N+1 item approach (no listing of pages, ''has next page'' can also be achieved by fetching an extra item) but with less drawback (no `OFFSET`) so I see limited benefits in maintaining a solution that only address performance concerns partially. Now that we have proper ''totally ordered'' expression inference in core there should be less obstacle to implementing cursor pagination than previously.