cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From aaron morton <>
Subject Re: Number of columns per row for Composite Primary Key CQL 3.0
Date Tue, 11 Sep 2012 01:37:04 GMT
In general wider rows take a bit longer to read, however different access patterns have different
performance. I did some tests here

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.
> -- 
> Thanks,
> Charlie (@mujiang) 木匠
> =======
> Data Architect Developer 汉唐 田园牧歌DBA

View raw message