how to avoid lightwieght transactions

2018-06-19 Thread manuj singh
Hi all, we have a use case where we need to update frequently our rows. Now in order to do so and so that we dont override updates we have to resort to lightweight transactions. Since lightweight is expensive(could be 4 times as expensive as normal insert) , how do we model around it. e.g i have a

Compaction strategy for update heavy workload

2018-06-13 Thread manuj singh
Hi all, I am trying to determine compaction strategy for our use case. In our use case we will have updates on a row a few times. And we have a ttl also defined on the table level. Our typical workload is less then 1000 writes + reads per second. At the max it could go up to 2500 per second. We use