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
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
>
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
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