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.