What would be the best way to paginate a query with Helenus?
29 views
Skip to first unread message
Edwin McKain
unread,
Jan 9, 2014, 5:08:37 PM1/9/14
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Sign in to report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to hel...@googlegroups.com
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
unread,
Feb 17, 2014, 12:04:53 PM2/17/14
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Sign in to report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to hel...@googlegroups.com
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.