1 large table (will reach 1-3 TB eventually) is using LCS. We decided on this compactionstrategy because this table is going to have lot of updates compared to inserts.
Is it right to believe that LCS is the better option for the large table mentionedabove?
No, LeveledCompactionStrategy is often not a good choice as a compaction strategy (though "your miles may vary").
In my experience, LCS is only suitable for data which rarely gets updated because LCS is quite aggressive in a sense that it will continuously compact SSTables in lower levels to coalesce/merge partition fragments (updated portions of a partition) into one SSTable.
For tables with a high update workload, the high IO requirements from the continuous compactions can significantly affect the performance of your cluster. Cheers!
5 People are following this question.
