Thanks again to Helen and Roman. This thread has been very educational.

Rick

----- Original Message -----

> At 06:59 AM 07-08-02 +0000, Roman Rokytskyy wrote:
>
> >If you want to avoid bottleneck, get a pool of IDs once and use them
> >one by one until you're out of IDs.
>
> I don't like this idea very much; though it *is* multi-user safe.
>
> >Generator incrementing used to be out of transaction control, so
> >you're on the safe side an no application will use the same ID.
>
> Not just "used to be out of transaction control". They used to be, are
> now, and always will be.
>
> >Generators are 32-bit integers, and suprisingly, that's a big number.
>
> Generators in Firebird and IB 6 --> are 64-bit integers - an exponentially
> bigger number!!
>
> Helen
>
>