FWIW. We have a strict policy of Surrogate Integer PK's. There are many
arguments to justify this, and few to justify the alternatives.

Don't ask me to elaborate. I don't want to get into a religious war.

T

-----Original Message-----
From: Alan McDonald [mailto:alan@...]
Sent: Monday, 24 May 2004 11:21 a.m.
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Re: Primary Keys - [was] Database File
Size

--- In firebird-support@yahoogroups.com, "Alan McDonald" wrote:
> > But it says something to those who are using UUIDs as PKs - thinking
> that it
> > gives them limitless keys for a 1000 years.
>
> The main attraction of UUIDS, is that they can be generated at
> different sites without collision.
>

If you need to have the client create the PKs, that's true. But for server
created PKs, integers can provide uniqueness without collision too. I am
asked many times about this and in 99% of cases integers will do the job
withou problem for much more than 1000 years.
Alan





Yahoo! Groups Links