Hi Rudi.
Look at this http://www.janus-software.com/fbmanual/manual.php?book=admin&topic=23
Consider to change DefaultDbCachePages in firebird.conf. You should read about this, because it depends if you use super server, classic or super classic.
DatabaseGrowthIncrement is a parameter that can affect the database performance too.
Hugo Eyng
I noticed our biggest data server have a lot of hard disk activity creating fb_lock files.
Firebird 2.5.4, superclassic
My changed lock configurations are :
#LockMemSize = 1048576
LockMemSize = 10097152
#LockHashSlots = 1009
LockHashSlots = 60589
Should I try to set them higher? If so, whats a good parameter to know by how much I should increase it?
-- Atenciosamente, Hugo Eyng
Posted by: Hugo Eyng <hugoeyng@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
No comments:
Post a Comment