Random UUID primary keys make SQLite inserts ten times slower
Using random UUID4 values as a primary key in SQLite forces inserts into random locations of the B‑tree, triggering costly page splits and rebalancing. Benchmarks show insert speed falling from ~1 M rows/sec with integer keys to under 100 k rows/sec with UUIDs.