[Lazarus] Postgres database again...

[Michael Van Canneyt]

On Wed, 28 May 2008, Graeme Geldenhuys wrote:

> 2008/5/28 Bogusław Brandys <brandys at o2.pl>:
> 
> Thanks for the information.
> 
> 
> > "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"
> 
> Sorry, but this might sound dumb... What what exactly does this mean?
> Am I supposed to change the GUID somehow?

Yes. It's best that the first characters of the GUID are the same as much as
possible. This way the index can be compressed better.

With totally random GUIDs, this is of course not possible, and therefore the 
indexes on GUIDs are much larger than they would be with numerical IDs.

Michael.