Subject RE: [firebird-support] Re: Page Size
Author Leyne, Sean

> I thought I would check our DB after reading this thread. We have a
> number of index depths of 3 (none above) our DB is using a page size
> 8192. I show the details of a couple of the more commonly used tables
> that have a high index depth. Are these bad, what sort of issues
> (performance wise) will this cause. Is the best way to deal with it
> increase the page size further?

In most cases; yes.

If you are using v1.x, upgrade to 2.0. The engine does a much better
job of handling indexes with large numbers of dups
(STOCKMOVEMENT_REGIONREF -- 65% of the records have a single value, with
574000 dups!!!)