README.md

Chapter 13 : Pagination

Item 94: When and Why Offset Pagination May Become a Performance Penalty

• OffsetPagination

Item 95: How to Optimize Offset Pagination with COUNT(*) OVER and Page<entity/dto>

• PageDtoOffsetPaginationWF
• ListDtoOffsetPaginationWF
• PageEntityOffsetPaginationExtraColumnWF
• ListEntityOffsetPaginationExtraColumnWF

Item 96: How to Optimize Offset Pagination with SELECT COUNT subquery and Page<entity/dto>

• PageDtoOffsetPagination
• ListDtoOffsetPagination
• PageEntityOffsetPaginationExtraColumn
• ListEntityOffsetPaginationExtraColumn

Item 97: How to Use JOIN FETCH and Pageable

• JoinFetchPageable

Item 98: How to Fix HHH000104

• HHH000104

Item 99: How to Implement Slice<T> findAll()

• SliceAllViaFetchAll
• SliceAllSimpleSql
• SliceAllCriteriaBuilder
• SliceAllCriteriaBuilderAndSort
• SliceAllCriteriaBuilderSortAndSpecification
• SliceAllCriteriaBuilderSortAndSpecificationAndQueryHints
• SliceAllCriteriaBuilderSimpleJpaRepository

Item 100: How to Implement Keyset Pagination

• KeysetPagination

Item 101: How to Add a Next Page Button to Keyset Pagination

• KeysetPaginationNextPage

Item 102: How to Implement Pagination via ROW_NUMBER()

• PaginationRowNumber