ScyllaDB now supports date-tiered compaction strategy

ScyllaDB 1.3 introduces the date-tiered compaction strategy, designed to enhance performance for time-series data by organizing data based on its timestamp to improve read efficiency. This strategy groups SSTables with similar timestamp ranges, reducing the need to consult multiple SSTables during queries, thus optimizing read performance for time-series workloads. Developed initially for Cassandra, it addresses inefficiencies of previous compaction strategies like size-tiered compaction by ensuring that newer data is prioritized and older, less relevant data is compacted efficiently. Despite its advantages, the date-tiered strategy has limitations, such as potential issues with memtable flushing and read repair, leading to the development of the Time Window compaction strategy as a more refined alternative. ScyllaDB plans to support this new strategy to better handle such limitations in the future.