Why Pagination in Spring Is not The Most Efficient Solution?

Things which Spring pagination tutorials do not talk about

Implement scalable and high performing pagination solution

I had a request from a business to develop a pagination feature for search transactions. “Sure”, I said. It was a simple solution with the Spring framework. But in our team meetings, one of our colleagues talked about using cursor-based pagination. It triggered further discussions on pagination and I found myself with no clear solution.

What we did next brought out a new perspective to the problem of pagination for us. I will list down the path to our solution below.

Offset-based pagination is the traditional way of implementing pagination. Clients need to supply two more parameters in their query: an offset, and a limit. An offset is the number of records you wish to skip before selecting records.

Related posts:

For more than the last decade, I have pushed through, endured, and worked harder than ever before to make sure my two kids and I had what we needed. Unlike some divorced single moms, I failed two…

Clive Jimmieson of Crossgate Capital — New Zealand’s first regulated share offer in a company investing in Bitcoin and other cryptocurrencies — says “investing in any asset class can be challenging…

Jedes Unternehmen hat Produkte und in jedem Fall auch einen Lebenszyklus der Produkte. Doch nicht jede Firma ist bereit, um diese zu institutionalisieren und zu leben. Erfahre mehr über den Nutzen…