Subject Re: Page Size
Author Adam
--- In firebird-support@yahoogroups.com, "Anderson Farias"
<peixedragao@...> wrote:
>
> Hi All,
>
> Is there any tips/advices on choosing a page size?

Test using as close to real-life data as you have. Using gstat, look
at the index depth, and if it is above 3, consider to increase the
page size.

There are other cases you may want to increase it. For example, in
Firebird 2, the size of the fields in a particular index is limited to
PageSize/4.

Generally speaking, there is no point using < 4K on todays computers

Adam