On 14/10/11 18:32, ramix001 wrote:

> Please tell me:
> - Does increasing then DefaultDbCachePages really help increasing the server performance?
> - If it does, are there more things I have to consider to make this formula work properly, e.g. database size, maximum/minimum values, usability with different Firebird versions starting with 1.5?
> - What functions do settings like FileSystemCacheSize and FileSystemCacheThreshold have in this context?

This might help with the cache and how to find out how many pages should
need to be cached :

http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/fbcache.html


There's a downloadable pdf at:

http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/Firebird-Cache.pdf

Cheers,
Norm.

--
Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL

Company Number: 05132767