logler: Three Rounds with the Profiler
Hierarchy building from 86 seconds to 332ms (259x). Search from 3.77s to 31ms (121x). Memory from 83 MB to 1 MB (83x). Two measurement bugs caught before they shipped.
3 posts
Hierarchy building from 86 seconds to 332ms (259x). Search from 3.77s to 31ms (121x). Memory from 83 MB to 1 MB (83x). Two measurement bugs caught before they shipped.
FTS rebuild from 4.65x to 1.03x (benchmark bug). Bulk insert from 1.9x to 0.89x (faster than raw sqlite). FTS ranked from 1.50x to 1.00x (single JOIN). Plus msgspec at 5.1x hydration.
Three targeted optimizations cut hierarchy building from 86 seconds to 349ms. A BTreeSet prefix index, cached investigators, and capped sampling — with before/after measurements proving every claim.