Tore,
>in our environment, with a maximum of 20 simultanous users, and fast servers, we have so far over the last 5 years maybe lost in total 10 seconds in waiting, and we can live with that! The GetNext.. function usually takes only a few milliseconds to execute, so the likelyhood of two users asking for a number at the same time is minimal. And, by the way, as far as I remember the function was made using VFP6, which did not have the autoincrement field type.
A higher user/transaction count would make lock contention a bigger issue. But it is a good point of reference that at 20 users it's not a problem.
>And you know, no need to fix it if it ain't broke. :-)
Most definately!