Hacker News new | ask | show | jobs
by coolspot 237 days ago
“client” here may refer to a backend app server. So you can have 10-100s of backend servers inserting into a same table without having a single authority coordinating IDs.
1 comments

That table is still a single authority, isn't it? But I guess fewer steps is still faster.
Except if you're using a sharding or clustering database system, where the record itself may be stored to separate servers as well as the key generation itself.
In those cases yes. There's still a case for sequential there depending on the use pattern, but write-heavy benefits from not waiting on one server for IDs.