Subject Re: [firebird-support] Buffers, DefaultDbCachePages and page size
Author Helen Borrie
At 09:21 PM 10/10/2003 +0000, you wrote:
>I'm trying to tune our database, and am confused between the
>DefaultDbCachePages in the firebird.conf (Firebird 1.5) and the
>buffers value that I see if I do setStatOn.
>Please could someone explain?!

They are different terms for the same thing. Both are the number of pages
of memory that will be allocated for the DbCache. Caching size and
behavior are different for Classic and Superserver.

>Also, how do I change the page size for the database?

Back it up with gbak and restore it with a new page_size. Don't use the
-r[estore] switch!! use -c[reate] and retain the old db until you're ready
to kick over to the new.

>Is there any up-to-date documentation for tuning a 1.5 database?

The "rules" (such as they are) haven't changed. The optimizer has changed
quite significantly. So keep to the existing guidelines and expect