Henrik Schröder <skrolle <at> gmail.com> writes: > But what's the difference between doing an extra read from that > One Big File, than doing an extra read from whatever SSTable > happen to be largest in the course of automatic minor compaction?
There is this note regarding major compaction in the tuning guide: "once you run a major compaction, automatic minor compactions are no longer triggered frequently forcing you to manually run major compactions on a routine basis" I think, this means that unless you run major compactions regularly, the number of sstables will naturally grow leading to incremental degradation in read performance for update workloads. Oleg