In general wider rows take a bit longer to read, however different access patterns have different performance. I did some tests here and

I would suggest 1MM cols is fine, if you get to 10MM cols per row you probably have gone too far. Remember the byte size of the row is also important; larger rows churn memory more and take longer to compact / repair.

Hope that helps. 

Aaron Morton
Freelance Developer

On 8/09/2012, at 11:05 AM, Data Craftsman ľ <> wrote:

Hello experts.

Should I limit the number of rows per Composite Primary Key's leading column?

I think it falls into the same wide row good practice for number of
columns per row for CQL 2.0, e.g. 10M or less.

Any comments will be appreciated.


Charlie (@mujiang) ľ
Data Architect Developer ԰DBA