New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

API Pagination SQL discussion #140

Open

cilim opened this issue Sep 29, 2021 · 0 comments

Member

cilim commented Sep 29, 2021

Page-based pagination

The ending of the subchapter for page-based pagination should be double checked:

The clause requires scanning all rows included by the offset value, which is inefficient for large offsets and causes performance to suffer the more pages you have (e.g. page 100 is slower to fetch than page 1).

@jerko-culina left a comment stating that the sentence might not be completely true, so let's discuss how we can improve it.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment