We have a requirement in our project for Cassandra Pagination.
We are using jQuery datatable in UI side for showing the records fetched by the select query.
But if the no of records are very huge like above 100000 and more, then there is a performance issue in jQuery datatable.
So,we need help to implement the pagination in Cassandra select-query row data.
For example if the select query returns more than 100000 rows of data, then we have to paginate it like 1 to 200, 201 to 400, 401 to 600, …. etc.
We can use “limit” here in the select query to fetch first 200 records.
But how we can fetch another 200 and next records so on.