How do write patterns affect reads?
It is important to consider how write operations affect read operations in the cluster. The compaction process is configurable and can significantly affect read performance. Using the SizeTieredCompactionStrategy (STCS) tends to cause data fragmentation when rows are frequently updated. The LeveledCompactionStrategy (LCS) was designed to prevent fragmentation under this condition, and is recommended for read-intensive workloads.