Subject Re: [IBO] Page Size
Author Helen Borrie
At 07:27 PM 1/08/2003 -0700, you wrote:
>hello all,
>In ibconnection there is a page size property. Is there any arithmetics in
>setting that property?

You can't set it on an extant database. It's a read-only property.
You set the page_size as an obligatory attribute on the CREATE DATABASE
statement. You can change it only by making a gbak backup and then
restoring the database with a new page_size property.

> For a DB with more than 150 tables and tens of thousands of records how it
> show be set?
> The DB page size is 1024, and buffer page size is 2048.
> The Server cache is 2048.
> I will be thankful if any one could enlighten me in this regard.

Off topic in IBO list, but suffice it to say that a 1K page_size is too
small for most purposes. 4K or 8K are the norm.
The buffer page size is ALWAYS the same as the database page size. You
have the default buffer (i.e. cache) configuration of 2048 pages. So your
cache is currently only 2K, again too small for most purposes.

For more, ask in firebird-support and get some of the background stuff on
configuration from the IBPhoenix site and the IB 6 beta docs.

Helen