Skip to main content

Pagination

  • Chapter
  • First Online:
Spring Boot Persistence Best Practices

Abstract

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 59.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 79.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Notes

  1. 1.

    https://use-the-index-luke.com/no-offset

  2. 2.

    https://www.slideshare.net/MarkusWinand/p2d2-pagination-done-the-postgresql-way?ref=https://use-the-index-luke.com/no-offset

  3. 3.

    HibernateSpringBootOffsetPagination

  4. 4.

    https://www.percona.com/blog/2007/08/28/to-sql_calc_found_rows-or-not-to-sql_calc_found_rows/

  5. 5.

    https://twitter.com/vlad_mihalcea/status/1207887006883340288

  6. 6.

    HibernateSpringBootPageDtoOffsetPaginationWF

  7. 7.

    HibernateSpringBootListDtoOffsetPaginationWF

  8. 8.

    HibernateSpringBootPageEntityOffsetPaginationExtraColumnWF

  9. 9.

    HibernateSpringBootListEntityOffsetPaginationExtraColumnWF

  10. 10.

    HibernateSpringBootPageDtoOffsetPagination

  11. 11.

    HibernateSpringBootListDtoOffsetPagination

  12. 12.

    HibernateSpringBootPageEntityOffsetPaginationExtraColumn

  13. 13.

    HibernateSpringBootListEntityOffsetPaginationExtraColumn

  14. 14.

    HibernateSpringBootJoinFetchPageable

  15. 15.

    HibernateSpringBootHHH000104

  16. 16.

    HibernateSpringBootSliceAllViaFetchAll

  17. 17.

    HibernateSpringBootSliceAllSimpleSql

  18. 18.

    HibernateSpringBootSliceAllCriteriaBuilder

  19. 19.

    HibernateSpringBootSliceAllCriteriaBuilderAndSort

  20. 20.

    HibernateSpringBootSliceAllCriteriaBuilderSortAndSpecification

  21. 21.

    HibernateSpringBootSliceAllCriteriaBuilderSortAndSpecificationAndQueryHints

  22. 22.

    HibernateSpringBootSliceAllCriteriaBuilderSimpleJpaRepository

  23. 23.

    HibernateSpringBootKeysetPagination

  24. 24.

    HibernateSpringBootKeysetPaginationNextPage

  25. 25.

    HibernateSpringBootPaginationRowNumber

Author information

Authors and Affiliations

Authors

Rights and permissions

Reprints and permissions

Copyright information

© 2020 Anghel Leonard

About this chapter

Check for updates. Verify currency and authenticity via CrossMark

Cite this chapter

Leonard, A. (2020). Pagination. In: Spring Boot Persistence Best Practices. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-5626-8_13

Download citation

Publish with us

Policies and ethics