Subject | Re: [IBO] Page Size |
---|---|
Author | Helen Borrie |
Post date | 2003-08-01T14:18:05Z |
At 07:27 PM 1/08/2003 -0700, you wrote:
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.
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
>hello all,You can't set it on an extant database. It's a read-only property.
>In ibconnection there is a page size property. Is there any arithmetics in
>setting that 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 itOff topic in IBO list, but suffice it to say that a 1K page_size is too
> 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.
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