#indexing

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 post ↗