What would be the best way to paginate a query with Helenus?

[Edwin McKain]

I'm working on a simple API for creating and listing items on Cassandra, but now I'm just working what would be the best way to paginate the response from this API?.

I don't have much data on Cassandra right now, but I can imagine to have thousands of rows and a simple 'select * from table' won't be efficient.

Thank you.

[Russell Bradberry]

So I typically use the "SELECT * LIMIT X" method then keep track of the key from the last row and then do a "SELECT * WHERE mykey > ? LIMIT X" for the next page.