42
The perils of UUID primary keys in SQLite (andersmurphy.com)
submitted 5 months ago by to c/programming@programming.dev
21 comments fedilink hide all child comments
you are viewing a single comment's thread
view the rest of the comments
[–] 3 points 5 months ago (2 children)

I would say their findings would be pretty consistent no matter which DBMS you use.

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 2 child comments
    •
  • [–] 9 points 5 months ago* (1 child)

    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.

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 1 child comment
    •