Re: Number of columns per row for Composite Primary Key CQL 3.0

2012-09-12 Thread Tristan Seligmann
On Wed, Sep 12, 2012 at 11:42 PM, aaron morton wrote: > > What is "MM" stands for? million ? > > Yup. > > No idea why I do that. I should note that some people use "1MM" to indicate "1 million milion" ie. 1 billion, so this might be doubly confusing for some ;) -- mithrandi, i Ainil en-Balandor,

Re: Number of columns per row for Composite Primary Key CQL 3.0

2012-09-12 Thread aaron morton
> What is "MM" stands for? million ? Yup. No idea why I do that. cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 12/09/2012, at 11:25 AM, Data Craftsman 木匠 wrote: > Hi Aaron, > > Thanks for the suggestion, as always. :) I'll read yo

Re: Number of columns per row for Composite Primary Key CQL 3.0

2012-09-11 Thread Data Craftsman 木匠
Hi Aaron, Thanks for the suggestion, as always. :) I'll read your slides soon. What is "MM" stands for? million ? Thanks, Charlie On Mon, Sep 10, 2012 at 6:37 PM, aaron morton wrote: > In general wider rows take a bit longer to read, however different access > patterns have different perfor

Re: Number of columns per row for Composite Primary Key CQL 3.0

2012-09-10 Thread aaron morton
In general wider rows take a bit longer to read, however different access patterns have different performance. I did some tests here http://www.slideshare.net/aaronmorton/cassandra-sf-2012-technical-deep-dive-query-performance and http://thelastpickle.com/2011/07/04/Cassandra-Query-Plans/ I wou

Number of columns per row for Composite Primary Key CQL 3.0

2012-09-07 Thread Data Craftsman 木匠
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 Archi