Conter wont be updated when the old data is TTLed. I am not sure whether you can use triggers https://issues.apache.org/jira/browse/CASSANDRA-1311
On Thu, Jul 18, 2013 at 2:30 PM, Kanwar Sangha <kan...@mavenir.com> wrote: > Hi - We are planning on using Cassandra for an IMAP based > implementation. There are some questions that we are stuck with –**** > > ** ** > > **1) **Each user will have a pre-defined mailbox size (say 10 MB). > We need to maintain a field to check if the mail-box size exceeds the > predefined size. Will using the counter family be appropriate ?**** > > **2) **Also, we need to have retention for only 10 days. After 10 > days, the previous days data will be removed. We plan to have TTL defined > per message. But if we do that, how does the counter in question 1 get > updated with the space cleaned due to deletion ?**** > > **3) **Do we NOT have TTL and manage the deletions within the > application itself ? **** > > ** ** > > Thanks,**** > > Kanwar**** > > **** >
