How To Implement Pagination Via ROW_NUMBER() Window Function
Description: This application is an example of using ROW_NUMBER() (and COUNT(*) OVER() for counting all elements) window function to implement pagination.
Key points:
- use a native query relying on
ROW_NUMBER() - we don't return a page as
PageorSlice, we return it asList, thereforePageableis not used
| If you need a deep dive into the performance recipes exposed in this repository then I am sure that you will love my book "Spring Boot Persistence Best Practices" | If you need a hand of tips and illustrations of 100+ Java persistence performance issues then "Java Persistence Performance Illustrated Guide" is for you. |
|
|
|
