Subject Re: [firebird-support] Optimum DefaultDbCachePages setting?
Author Dmitry Yemanov
Milan Babuskov wrote:
>
>> Currently using:
>> DefaultDbCachePages = 8192
>> Main database page size = 8192
>
> This means 64MB (8k x 8kB) of database file is kept in cache. I don't
> know how well Windows caches the filesystem, but it looks like
> increasing the setting could benefit you a lot. I'd try increasing the
> value 8 or 16 times to see what happens.

Only if there are no massive modifications. FB 1.5 is known to have
performance issues with the buffer cache bigger than ~10K pages.


Dmitry