2 ms·
Another downside of offset-based pagination is less consistent handling of data changes during pagination. If any row is inserted anywhere before the page you
by pornel 4y ago
Another downside of offset-based pagination is less consistent handling of data changes during pagination.
If any row is inserted anywhere before the page you requested, you'll see some other item twice (once at the end of the previous page, then again at the top of the next page). Similarly if any item was removed, you'll skip over some other item when paginating due to every page shifting by one.
- catlifeonmars 4y agoI’d take it further: offset based pagination failure modes look different based on the implementation. If you have API clients, you’re exposing that implementation detail to them.
- cortesoft 4y agoThat was mentioned as a con for offset based pagination.