osius"
> Sent: Tue, March 13, 2012 13:43
> Subject: Re: Why is row lookup much faster than column lookup
>
> < div clas s="PrivateMsgDiv"> Given the hashtable nature of cassandra,
> finding a row is probably 'relatively' constant no matter how ma
sorry, should have been: Given the hashtable nature of cassandra, finding a
row is probably 'relatively' constant no matter how many *rows* you have.
- Original Message -From: "Dave Brosius"
>;dbros...@mebigfatguy.com
Given the hashtable nature of cassandra, finding a row is probably 'relatively'
constant no matter how many columns you have.The smaller the number of columns,
i suppose the more likely that all the columns will be in one sstable. If
you've got a ton of columns per row, it is much more likely th
>From my tests, I am seeing that a CF that has less than 100 columns
but millions of rows has a much lower latency to read a column in a
row than a CF that has only a few thousands of rows but wide rows with
each having 20K columns.
Example:
cf1 has 6 Million rows and each row has about 100 column
