SQLite UUIDs tank performance by 300 percent
Random UUIDs as primary keys in SQLite cause page splits that triple insertion time. Integer keys stay fast because SQLite is built for sequential writes.
Read the note 1 min read
From the notebook
database-performance.
1 note on this topic.