cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dan Hendry" <>
Subject RE: How do you implement pagination?
Date Sat, 11 Dec 2010 03:01:49 GMT
Or you can just start at the 1 + nth id given ids must be unique (you don't
have to specify an existing id as the start of a slice). You don't HAVE to
load the n + 1 record. 


This (slightly) more optimal approach has the disadvantage that you don't
know with certainty when you have reached the end of all records. This may
or may not be acceptable for your application.




From: [] On Behalf Of
Joshua Partogi
Sent: December-10-10 21:05
Subject: Re: How do you implement pagination?


So you're actually getting n+1 record? Correct? So this is the right way to
do it?

On Sat, Dec 11, 2010 at 1:02 PM, Tyler Hobbs <> wrote:

Yes, what you described is the correct way to do it.  Your next slice will
start with that 11th column.

- Tyler


On Fri, Dec 10, 2010 at 7:01 PM, Joshua Partogi <>

Hi all,

I am interested to see people's way to do record pagination with cassandra
because I can not find anything like MySQL LIMIT in cassandra. 

>From what I understand you need to tell cassandra the Record ID for the
beginning of the slice and the number of record you want to get after that
Record. I am using UUID instead of Long for the Record ID. 

My question is, how does your application get the next Record ID after the
current slice that is displayed on the page? 
Let's say I want to display record 1-10, do I actually grab 11 records but
only display 10 records and only keep the ID of the 11th records so I can
use it for pagination?

Sorry if the question is a bit obscured, but I am still figuring out how to
do pagination. 

Thanks very much for your assistance.

Kind regards,

-- <> 



No virus found in this incoming message.
Checked by AVG -
Version: 9.0.872 / Virus Database: 271.1.1/3307 - Release Date: 12/10/10

View raw message