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
