Item 94: When and Why Offset Pagination May Become a Performance Penalty
Offset pagination is very popular and Spring Boot (more precisely, Spring Data Commons) provides support for it via the Page and Slice APIs. However, while your project evolves and data is accumulating, relying on offset pagination may lead to performance penalties even if it was not an issue at the start of the project.
Dealing with offset pagination means you can ignore the performance penalty induced by throwing away n records before reaching the desired offset. A larger n leads to a significant performance penalty. ...
