The performance cost of random UUID primary keys in SQLite and clustered indexes

This article examines the performance drawbacks of using random UUIDs (specifically UUID4) as primary keys in SQLite databases. It explains how the unordered nature of random UUIDs causes excessive paging and B-tree rebalancing in clustered indexes, leading to significant perform