Re: Why is row lookup much faster than column lookup

2012-03-14 Thread aaron morton
, 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 many columns you have. The smaller the number of columns, i suppose the more

Re: Why is row lookup much faster than column lookup

2012-03-13 Thread Dave Brosius
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

Re: Why is row lookup much faster than column lookup

2012-03-13 Thread Dave Brosius
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: quot;Dave Brosiusquot; ;dbros...@mebigfatguy.com