Subject | RE: [firebird-support] Re: Primary Keys - [was] Database File Size |
---|---|
Author | Alan McDonald |
Post date | 2004-05-23T23:21:04Z |
--- In firebird-support@yahoogroups.com, "Alan McDonald" wrote:
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
> > But it says something to those who are using UUIDs as PKs - thinkingIf you need to have the client create the PKs, that's true. But for server
> 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.
>
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