Subject | Re: [firebird-support] Optimum DefaultDbCachePages setting? |
---|---|
Author | Dmitry Yemanov |
Post date | 2008-05-06T11:49:37Z |
Milan Babuskov wrote:
performance issues with the buffer cache bigger than ~10K pages.
Dmitry
>Only if there are no massive modifications. FB 1.5 is known to have
>> 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.
performance issues with the buffer cache bigger than ~10K pages.
Dmitry