На Thu, 16 Nov 2006 15:19:43 -0500
"Ann W. Harrison" <aharrison@...> написа:

> adrian_avila_mtz wrote:
> > Is there any performance test comaparing them?
> >
>
> There have been performance tests, but there is no
> single definitive test. In many cases, Firebird 2
> is faster than Firebird 1.5. In a few, it's slower
> but it gets the right answer consistently. No
> doubt there are some odd conditions where 1.5 is
> faster and gets the right answers.
>
> Two areas where you will definitely notice performance
> improvements are index garbage collection with long
> strings of duplicate values, and general index performance
> with large page sizes.
>

I also see speed up of 10-50% (sometime with times) for many of my
complex chain of views where I have 15+ INNER/OUTER joined tables. The
main reason for that I see in more precise use of indexes and better
plans from optimizer.

Cheers,
--
Miroslav Penchev