this http://thelastpickle.com/2011/07/04/Cassandra-Query-Plans/
> A.) At what column count does this happen? Based on column serialised size https://github.com/apache/cassandra/blob/trunk/conf/cassandra.yaml#L325 > B.) If Thrift is only getting slices of a large row (column_start=X, > column_end=Y, limit 20) is their any performance hits to rows over and above > the A.) threshold above? Anything with a start column, or using reverse will need to use the column index if it is present. > Finally, I am correct in thinking the cluster may appear slightly unbalanced > depending on the RF and the amount of nodes with a great deal of large rows? Yes if you have RF > cluster size. Cheers ----------------- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 21/02/2012, at 7:45 AM, Blake Starkenburg wrote: > Question pertaining to wide or large rows in Cassandra. I recall reading in a > blog I believe posted by Aaron Morton a notation that Cassandra creates its > own index of a row when it reaches X amount of columns? My curiosity is: > > A.) At what column count does this happen? > B.) If Thrift is only getting slices of a large row (column_start=X, > column_end=Y, limit 20) is their any performance hits to rows over and above > the A.) threshold above? > > Finally, I am correct in thinking the cluster may appear slightly unbalanced > depending on the RF and the amount of nodes with a great deal of large rows? > > note: using php_cassa & Cassandra 0.8.10 > > Thanks!