Hi Adam,

Ok, so... as I understood, as far as the max index depths I have is 3, there is no need to use a page size above 4k.

Many thanks for your tips!

Regards,
Anderson

----- Original Message -----
From: Adam
To: firebird-support@yahoogroups.com
Sent: Tuesday, July 10, 2007 10:00 PM
Subject: [firebird-support] Re: Page Size


--- 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





[Non-text portions of this message have been removed]