Subject RE: [firebird-support] Re: Primary Keys - [was] Database File Size
Author Alan McDonald
--- 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