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

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
______________________________________________________________________