Ann W. Harrison wrote:

> Yes in the case of index duplicates. Also yes in the case of
> compressing guid fields. Firebird 2 has a much more sophisticated
> compression algorithm and uses indexes within indexes to improve
> performance on large page sizes.

I need to get a system running a a large volume of data on FB1.5, to get
some timing figures to work with, but I suspected FB2 will handle either
setup better. I'm just used to pruning has much unnecessary data as
possible, so old habits are hard to kill.

> But, if I can make a suggestion, don't get into a theoretical p*sing
> match with the Postgres guys. Build a sample and test it.

I intended to, but I needed a base to work from. Once I have a few base
tests to work with .....

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services
Treasurer - Firebird Foundation Inc.