Your SQLite Inserts Got 10× Slower — and a Random UUID Did It

This site does not allow itself to be embedded. You can still read it on the original site — the toolbar below keeps your place in the directory.

You switched your primary key from an auto-incrementing integer to a random UUID. There are good reasons to: IDs you can generate on the client without a round trip, IDs that don’t leak how many rows you have, IDs that won’t collide when you merge two databases. At first everything is fine. Inserts are fast. Then the table grows. And grows. And one day you notice writes are crawling — not a little…

Read on pickles.news ↗