Re: Question about how compaction and partition keys interact

2014-03-27 Thread Jack Krupansky
If the number of types and dates per customer are reasonable modest (dozens? hundreds?) it may not matter much at all. What are the numbers here, average/maximum types per customer and dates per customer? In fact, depending on the numbers, maybe the partition key should only be the customer. I m

Re: Question about how compaction and partition keys interact

2014-03-27 Thread Jonathan Lacefield
ys a date. > > > > Thanks, Don > > > > *From:* Jonathan Lacefield [mailto:jlacefi...@datastax.com] > *Sent:* Wednesday, March 26, 2014 11:20 AM > *To:* user@cassandra.apache.org > *Subject:* Re: Question about how compaction and partition keys interact >

RE: Question about how compaction and partition keys interact

2014-03-26 Thread Donald Smith
Don From: Jonathan Lacefield [mailto:jlacefi...@datastax.com] Sent: Wednesday, March 26, 2014 11:20 AM To: user@cassandra.apache.org Subject: Re: Question about how compaction and partition keys interact Don, What is the underlying question? Are trying to figure out what's going to be fa

Re: Question about how compaction and partition keys interact

2014-03-26 Thread Jonathan Lacefield
Don, What is the underlying question? Are trying to figure out what's going to be faster for reads or are you really concerned about storage? The recommendation typically provided is to suggest that tables are modeled based on query access, to enable the fastest read performance. In your