Subject | Re: [firebird-support] What type to use for primary key? |
---|---|
Author | Martijn Tonies |
Post date | 2004-04-28T10:41:27Z |
Hi,
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
> I am designing big database, where will be one generator that willUse NUMERIC(18, 0)
> 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?
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com