How ScyllaDB’s Trie-Based Index Delivers Up to 3X More Throughput
Summary
The article explains ScyllaDB's switch to a Trie-based index format, replacing Summary.db and Index.db with a two-file SSTable design (Partitions.db and Rows.db). It reports significant read-performance gains (up to 3x, with 20%-230% throughput increases and 31%-63% latency reductions) across multiple workloads, while write impact remains negligible. It also covers architecture details, page packing optimizations, and benchmarks, noting Trie as the default index format in ScyllaDB 2026.2.