cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michal August├Żn <>
Subject Re: skip + limit support in GetSlice
Date Sun, 05 Sep 2010 19:30:49 GMT
I know that "Prev/Next" is good solution for web applications. But when I
want to access data from another application or when I want to access pages

I don't know the internal structure of memtables etc., so I don't know if
columns in row are indexable. If now, then I just want to transfer my
workaround to server (to avoid huge network traffic)...

2010/9/5 Stu Hood <>

> Cassandra supports the recommended approach from:
> For large numbers of items, skip + limit is extremely inefficent.
> -----Original Message-----
> From: "Michal August├Żn" <>
> Sent: Sunday, September 5, 2010 5:39am
> To:
> Subject: skip + limit support in GetSlice
> Hello,
> probably this is feature request. Simply, I would like to have support for
> standard pagination (skip + limit) in GetSlice Thrift method. Is this
> feature on the road map?
> Now, I have to perform GetSlice call, that starts on "" and "limit" is set
> to "skip" value. Then I read the last column name returned and subsequently
> perform the final GetSlice call - I use the last column name as "start" and
> set "limit" to "limit" value.
> This workaround is not very efficient when I need to skip a lot of columns
> (so "skip" is high) - then a lot of data must be transferred via network.
> So
> I think that support for Skip in GetSlice would be very useful (to avoid
> high network traffic).
> The implementation could be very straightforward (same as the workaround)
> or
> maybe it could be more efficient - I think that whole row (so all columns)
> must fit into memory so if we have all columns in memory...
> Thank you!
> Augi

View raw message