> a) "These queries are not easily supported on standard Cassandra"
> select * from book where price < 992 order by price descending limit 30;
>
> This is a typical (time series data)timeline query well supported by
> Cassandra, from my understanding.
Queries that use a secondary index (on pric
Hi Aaron,
Thanks for the quick answer, I'll build a prototype to benchmark each
approach next week.
Here are more questions based on your reply:
a) "These queries are not easily supported on standard Cassandra"
select * from book where price < 992 order by price descending limit 30;
This is
> We need to query data by each column, do pagination as below,
>
> select * from book where isbn < "XYZ" order by ISBN descending limit 30;
> select * from book where price < 992 order by price descending limit 30;
> select * from book where col_n1 < 789 order by col_n1 descending limit
Will 1500 bytes row size be large or small for Cassandra from your
understanding?
performance degradation starts at 500MB rows, its very slow if you hit
this limit.
