The perils of UUID primary keys in SQLite

UUID4 primary keys in SQLite trigger significant extra paging due to random insertion order. The B-tree index must re-balance frequently as rows are inserted out of sequence. SQLite's default rowid primary key maintains ordered storage with predictable performance. Without ROWID tables, declared primary keys become clustered indexes and introduce performance degradation. The test shows 10 million row inserts take longer with UUIDs than with integer rowid keys.