Re: Writing the same column frequently - anti pattern?

2015-02-06 Thread Jens Rantil
Hi, If the writes are coming from the same machine, you could potentially use request collapsing to avoid the duplicate writes. Just an idea, Jens On Fri, Feb 6, 2015 at 1:15 AM, Andreas Finke wrote: > Hi, > > we are cur

Re: Writing the same column frequently - anti pattern?

2015-02-05 Thread Robert Coli
On Thu, Feb 5, 2015 at 4:15 PM, Andreas Finke wrote: > we are currently writing the same column within a row multiple times (up > to 10 times a second). I am familiar with the concept of tombstones in > SSTables. My question is: I assume that in our case in most cases when a > column gets overwr

Re: Writing the same column frequently - anti pattern?

2015-02-05 Thread Jonathan Haddad
Well... this is actually only true if your server times are perfectly in sync. The reality is if 1 server is 50ms ahead and 1 is 50 behind, your will actually end up with unpredictable results. On Thu Feb 05 2015 at 4:22:43 PM Philip Thompson < philip.thomp...@datastax.com> wrote: > You are corr

Re: Writing the same column frequently - anti pattern?

2015-02-05 Thread Philip Thompson
You are correct. If an overwrite occurs while the original is still in the memtable, only the newest will be flushed to disk. On Thu, Feb 5, 2015 at 6:15 PM, Andreas Finke wrote: > Hi, > > we are currently writing the same column within a row multiple times (up > to 10 times a second). I am fa

Writing the same column frequently - anti pattern?

2015-02-05 Thread Andreas Finke
Hi, we are currently writing the same column within a row multiple times (up to 10 times a second). I am familiar with the concept of tombstones in SSTables. My question is: I assume that in our case in most cases when a column gets overwritten it still resides in the memtable. So I assume for