It's impossible to implement offset either performantly or safely in a
distributed log-structured merge system that supports deletes. The
original API punted on all three of those. 0.4 doesn't. See
https://issues.apache.org/jira/browse/CASSANDRA-261 for a discussion
of performance (we decided
Pagination is an extremely common use case scenario in web app programming.
almost every web app need “one to many” data model. when the “many” part is
too many to fit in one page, paginate is the best way to resolve it. in most
case, we don't need query or sort the result in a complicated
Stabilizing but not quite finished (329 and 311 are still waiting for
review). But the fundamentals are the same.
You have start/finish because that's what defines a range. You have
count because you often want the First N results.
-Jonathan
On Sat, Aug 8, 2009 at 8:33 AM, Jonas
Count is always the max number of results to return.
So it means, starting with `start`, or the first one if start is
empty, go until you hit `finish` or `count`, whichever comes first.
Empty is not a legal column name so if finish is empty it is ignored
and only count is used.
We don't offer a