Re: Cassandra Secondary index/Twissandra

2011-07-11 Thread Eldad Yamin
Hi Aaron, Thank you again for your response. I've read the article but I didn't understand everything. it would be great if the benchmark will include the actual CLI/Python comments (that way it will be easier to understand the query). in addition, an explanation about row pages - what is it?. An

Re: Cassandra Secondary index/Twissandra

2011-07-10 Thread aaron morton
> Can you recommend on a better way of doing that or a way to tune Cassandra to > support those 2 CF? A select with no start or finish column name, a column count and not in reversed order is about the fastest read query. You will need to do a reversed query, which will be a little slower. But

Re: Cassandra Secondary index/Twissandra

2011-07-10 Thread Eldad Yamin
Aaron - Thank you for the fast response! 1. Does performance decrease (significantly) if the uniqueness of the column’s name is high when comparator is LONG_TYPE/TimeUUID and each row has lots of columns? >Depends on what sort of operations you are doing. Some read operations have to pa

Re: Cassandra Secondary index/Twissandra

2011-07-09 Thread aaron morton
> Is there a limit on the number of columns in a single column family that > serve as secondary indexes? AFAIK there is no coded limit, however every index is implemented as another (hidden) Column Family that inherits the settings of the parent CF. So under 0.7 you may run out of memory, under