Serial Numbers: On Commit vs On Create
I'm trying to figure out some scenarios when to use On Commit vs. On Create. I understand technically what each option does and when it fires, but I'm curious in what scenarios I would use one verses the other. It seems like having multiple users of a single database would favor On Create, so you don't get repeating values.
Are there examples when one or the other might not work correctly? Which do you tend to use?
First, you will (hopefullly) not get a duplicate in ANY scenario.
Your question is a little too broad, but in general I think one would use On Commit in solutions where consecutive numbering is important, and records are not allowed to be deleted once committed.