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?