3 ms·

Why have a bigint numerical ID at all?

• ringeryless 1y ago
  fast lookup for internal usage. it's significantly faster than a UUID on every DBMS i have ever seen
  • Jarwain 1y ago
    That's a good reason! I think with UUIDv7, because it's sequential it's indexes are faster than UUIDv4. Still larger than bigints though. I'd like to do a benchmark at some point