Subject RE: [firebird-support] GUID as PK
Author Alan McDonald
> I think I read somewhere that long strings such as GUIDs for PK's in
> Firebird were problematic. Is there any truth to this?
>
> Thanks,
>
> --
> Warm Regards,
>
> Lee

not probmelatic but to some degree, annoyance.
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