When should I choose LSM-trees over B-trees?
Use LSM-trees for write-heavy workloads with high throughput targets (millions of writes/sec) where occasional read latency spikes are acceptable. Use B-trees for balanced or read-heavy workloads where consistent query latency matters more than write throughput, like OLTP systems.
Answered in
LSM-Trees vs B-Trees: Why Cassandra Chose Sequential WritesB-trees seek random disk positions. LSM-trees buffer in memory and flush sequentially, converting random I/O into sequential writes for millions of ops/sec.
Read the full analysisOther questions this article answers
More system design questions
- Why doesn't Google just run Dijkstra faster?
- What is a shortcut edge and when is it precomputed?
- How much space do shortcut edges take compared to the original graph?
- Can Contraction Hierarchies handle dynamic graphs like traffic or road closure?
- Why contract low-degree nodes first instead of high-degree ones?
- What is a CRDT and why does it matter for real-time collaboration?
- How do CRDTs handle concurrent edits without a central server referee?
- Why did Figma move from operational transforms to CRDTs?
Every answer on Crashtech is written by the editor of the article it comes from — never auto-summarised. Browse all answers or the System Design beat.