At 01:34 PM 4/9/2004, Brad Pepers wrote:

> >> Wouldn't it make sense to convert the GUID to/from base64 ...
>I suppose so though base64 isn't anything odd or binary. You can easily
>represent it with the characters A-Z, a-z, 0-9, and two other normal
>characters so it is just regular text. ...
>Seems to me to be a simple change that uses less space, might make selects
>faster when you have tons of records, and doesn't lose you anything in human
>readability!

As you are transforming your GUID, try to keep the least volatile bytes at
the front and the most volatile at the end. Firebird uses prefix
compression in its indexes and the saving in space on the index pages
absolutely will improve performance on all but the most trivial data sets.

Ann