Subject | RE: [firebird-support] GUID as PK |
---|---|
Author | Alan McDonald |
Post date | 2007-10-17T21:38:50Z |
> I think I read somewhere that long strings such as GUIDs for PK's innot probmelatic but to some degree, annoyance.
> Firebird were problematic. Is there any truth to this?
>
> Thanks,
>
> --
> Warm Regards,
>
> Lee
there's a UDF which generates UUID - better than GUID for FB indexing, so
use it and not GUID generation.
other annoyances,
more disk space (it's cheap)
impossible to humanly determine record creation sequence without additonaly
timestamp (more disk splace - it's cheap)
there are other ways to guarantee unique keys but using BIGINT instead.
more load on transport protocol when transferring data OTW
there may be others
Alan