Well it’s not like that. We don’t just purge. There are business rules which 
will decide the records to be purged or archived and then purged, so cannot 
rely on TTL.


From: Jens Rantil <jens.ran...@tink.se>
Reply-To: "user@cassandra.apache.org" <user@cassandra.apache.org>
Date: Tuesday, March 6, 2018 at 12:34 AM
To: "user@cassandra.apache.org" <user@cassandra.apache.org>
Subject: Re: One time major deletion/purge vs periodic deletion

Sounds like you are using Cassandra as a queue. It's an antibiotic pattern. 
What I would do would be to rely on TTL for removal of data and use the TWCS 
compaction strategy to handle removal and you just focus on insertion.
On Tue, Mar 6, 2018, 07:39 Charulata Sharma (charshar) 
<chars...@cisco.com<mailto:chars...@cisco.com>> wrote:

      Wanted the community’s feedback on deciding the schedule of Archive and 
Purge job.
Is it better to Purge a large volume of data at regular intervals (like run A&P 
jobs once in 3 months ) or purge smaller amounts more frequently (run the job 

Some estimates on the number of deletes performed would be…upto 80-90K  rows 
purged in 3 months vs 10K deletes every week ??



Jens Rantil
Backend Developer @ Tink

Tink AB, Wallingatan 5, 111 60 Stockholm, Sweden
For urgent matters you can reach me at +46-708-84 18 32.

Reply via email to