Great link, thanks.
On Fri, Jul 19, 2013 at 9:40 AM, CharSyam <chars...@gmail.com> wrote: > How about this: > http://www.elasticinbox.com/ > > 2013년 7월 19일 금요일에 Vegard Berget<p...@fantasista.no>님이 작성: > > > Hi, > > 1) Counters will probably work for this. Our experience with counters > is that it is very accurate. But read up on how repair/inconsistencies etc > is handled. > > 2) You can not, as far as i know at least, have ttl on part of a > counter. What you can do, depending on how accurate it needs to be, is to > have counters per hour (or something like that) and add them together for > the last 10 days (which of course can be done async and stored): > > MailboxId as rowkey, Year,Month,Day,Hour as columnkey. I don't know > if this solves anything for you, but maybe you can use part of that idea > for something? > > .vegard, > > > > ----- Original Message ----- > > From: > > user@cassandra.apache.org > > To: > > "user@cassandra.apache.org" <user@cassandra.apache.org> > > Cc: > > Sent: > > Thu, 18 Jul 2013 21:30:08 +0000 > > Subject: > > MailBox Impl > > > > > > 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 > > > > > -- Vladimir Prudnikov