Hi
If you use the returning clause on the first statement you don’t get a
extra round trip to the database to get the sequence.
Med venlig hilsen
Peter Gram
Sæbyholmsvej 18
2500 Valby
Mobile: (+45) 5374 7107
Email: peter.m.gram@xxxxxxxxx
On Wed, 10 Apr 2024 at 23.38, ahmed.fikri@xxxxxxxxxxx <
ahmed.fikri@xxxxxxxxxxx> wrote:
Hi there,
Once more, a question about fundamentals:
In several Hibernate projects, I've observed developers leaning towards
using UUIDs as primary keys instead of numerical values. This preference
likely stems from the avoidance of sequences for numerical primary keys,
which necessitate round trips to the database after each insertion.
Additionally, there's a concern about potential contention with sequences,
and some developers may prefer to avoid predictability in the next
generated value. Personally, I remain skeptical about the widespread use of
UUIDs due to their larger storage footprint (both in tables and indexes)
compared to numerical IDs. Numeric IDs also offer benefits in issue
analysis. However, it's worth noting that Hibernate employs algorithms to
minimize round trips to the database, effectively reducing their impact.
Could you please share your experience and preference? What choice would
you make?
Regards
Ahmed
