Subject RE: [firebird-support] What type to use for primary key?
Author Alan McDonald
> Hello,
>
> I am designing big database, where will be one generator that will
> generate values for primary keys of all tables (so all records in all
> tables will be unique). Integer is too small for primary key I decided
> to use NUMERIC(15,1). Will it slow down performace? What is
> generator's max size? What type to use?
>

Use a BIGINT or INT64 you get
9,223,372,036,854,775,807
positive value
You also get the same in negative values. You can set the generator
to -9,223,372,036,854,775,807 to start if you want.
Big enough?

But why on earth do you wnat to use only one generator?
Alan