3 ms·
Sounds like you're using offset for pagination. https://use-the-index-luke.com/no-offset https://use-the-index-luke.com/no-offset
by andreareina 6y ago
Sounds like you're using offset for pagination.
https://use-the-index-luke.com/no-offset https://use-the-index-luke.com/no-offset
- VentScape 6y agoA bit more explanation for you or any other helpful people reading, I'm using Spring's PagingAndSortingRepository.findAll(Pageable) function, and then passing in sort=id,desc&size=10 via the API request params (but no explicit offset AFAIK). Found one potentially good stackoverflow to dig into so far https://stackoverflow.com/questions/44021665/why-is-a-paginated-query-slower-than-a-plain-one-with-spring-data https://stackoverflow.com/questions/44021665/why-is-a-pagina...