But that’s the thing with benchmarks, you run them because making assumptions about performance based on guesswork often fails. SQLite is very much architecturally unique for being a daemon-less database that doesn’t concern itself with concurrent writes.
Is UUID as pk slower than int or bigints? Probably - you’re storing 4x more data than a 32-bit integer. Does it matter? Probably not.
But that’s the thing with benchmarks, you run them because making assumptions about performance based on guesswork often fails. SQLite is very much architecturally unique for being a daemon-less database that doesn’t concern itself with concurrent writes.
Is UUID as pk slower than int or bigints? Probably - you’re storing 4x more data than a 32-bit integer. Does it matter? Probably not.
UUID could be slower for SQLite. If you have a SEQUENCE and millions of concurrent writes you have other problems.