Alan McDonald wrote:

>
>>I've been looking on the ibphoenix site for docs on
>>strategy/methodology for choosing the optimal paging size. I couldn't
>>find one (maybe I missed one) - do you know of any docs/links covering
>>this?
>>
>
> AFAIK there is no real science to it. It very much depends on how many
> blob/large varchar fields you have in a table and what sort of queries you
> expect to use.

There is one mildly scientific aspect to choosing a page size. A larger
page size reduces the depth of index trees, which reduces the cost of an
index lookup. Use gstat -a to get a report of index depths. If any
indexes are more than three levels deep, increase the page size.

Regards,


Ann