3 parts
A measured diagnostic tree for slow Rust builds: cargo --timings for the shape, the fingerprint log for unexpected rebuilds, -Ztime-passes for the phase inside one crate, and what splitting a workspace into more crates actually changes.
Evidence: experiments/rust-atlas/build-times/
10 parts
Ten parts on what an index really is, measured on a SQLite table of one million rows: a second sorted copy of the data, SCAN against SEARCH, the cost on every insert, column order, covering indexes, the cases where the planner ignores an index, statistics that go stale, partial and expression indexes, free pages and VACUUM, and a search index kept in sync.
Evidence: experiments/inside-a-database-index/