---
answer: direct
beat: system-design
source: 1 article · updated: November 14, 2026
---

Why copy data in sorted order when bulk loading?

Databases keep data in B-tree structures. Inserting in key order writes to neighbouring pages, which improves cache use and avoids page splits. Stripe reported roughly a tenfold gain in write throughput from sorting by the most common index attributes before inserting.

Answered in

Moving Live Data Between Shards With Zero Downtime: The Six-Step Protocol

Register, bulk copy, replicate the tail, verify, flip traffic behind a version gate, clean up. How online shard migrations work without losing a write.

Crashtech Editorial November 14, 2026 System Design & Architecture

Read the full analysis

Other questions this article answers

More system design & architecture questions

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 & Architecture beat.