Subject | RE: [firebird-support] What type to use for primary key? |
---|---|
Author | Alan McDonald |
Post date | 2004-04-28T10:44:07Z |
> Hello,Use a BIGINT or INT64 you get
>
> 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?
>
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