On 10/16/25 20:26, Kapil Panchal wrote:
While UUIDs or Snowflake IDs can marginally improve primary-key lookup times via O(log n) algorithms
Over what? I don't follow. We're comparing those with traditional auto-incrementing primary keys, and lookups based on /those/ IDs are going to be O(1) time complexity.
Kapil, surely we'll also need to consider indexing of primary keys (be they bigints, uuids, or snowflake ids) and query/search optimization, but that sounds like a separate thread. See Ádám's post starting this thread <https://lists.apache.org/thread/grkgqt1tv4wdhdw6zwsxjqtnbwqm5xfo>: The main reason for switching from db-derived auto-increment primary keys is to work around issues with using the db to generate them (performance, maintenance, security, etc).
-- Adam Monsen Software Engineer ~ Mifos Initiative Apache Fineract Release Manager PGP key id 0xA9A14F22F57DA182
