Subject Re: [firebird-support] Optimum DefaultDbCachePages setting?
Author Milan Babuskov
Tom Conlon wrote:
> If someone has any experience on the best value for the above I'd much
> appreciate it:
> 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.

> Db Server spec:
> ~ 80 users
> 3.83GB Ram
> Win 2003 Server 2003 R2 SP1

Milan Babuskov