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
http://www.flamerobin.org