I have to paginate the records with 10 records per page. I can do this through the limit and offset. But the server call will be expensive if we go for every 10 records.
So I would change the Limit to 100, but the pagination size would be still 10. Once the 100 records are processed, then only I should go for the server to fetch the next set of 100 records on click of Next or previous. Need help in writing the logic for the above especially on click of Next and Previous buttons