Subject Re: [firebird-support] GUID as Primary Key
Author Ann W. Harrison
>On Tuesday 02 March 2004 16:31, David Johnson wrote:
> > My question: Is there a more efficient way that I can use GUID's. I
> > have read on this list people achieving sub 1 second transactions

At 05:14 PM 3/2/2004, Jaume Sabater wrote:
>I think you could get better results in case you use integer type, in case
>that fits your needs, since comparing integers is always faster than
>comparing strings.

In the case of Firebird indexes, that's not true. All keys are manipulated
so they compare bytewise. An eight byte string and an int64 take the same
amount of time to compare.



BTW, prefix compression, not index balance, is the reason to put the
unchanging part of the key first.