# Configuration file for Firebird 2.5 32-bit Classic, by IBSurgeon (www.ib-aid.com), released March 23, 2020
# This is an optimized configuration for Firebird 2.5 32-bit Classic, it can be used
# instead of standard firebird.conf from 2.5 distribution for small and moderate loaded servers.


##############  Important! Limits ! ###############
##############  If you have more than 300 total connections for all databases
##############  and less than 16 Gb of RAM, don't use this configuration!
#######################################################################


###########   HOW TO APPLY this Firebird Configuration   ############
###    1. Run gstat -h  databasename and ensure that Page Buffers = 0 - for every database.
###    2. Copy this firebird.conf to Firebird folder, rename it to firebird.conf, then restart Firebird 
###      (all users should be disconnected before restart!). Keep old config as a backup!
################################################################

# Any questions? Contact us: support@ib-aid.com

DefaultDbCachePages = 1200
TempBlockSize = 2048576
TempCacheLimit = 67108864
LockMemSize = 30048576
LockHashSlots = 49999

#RootDirectory =
#DatabaseAccess = Full
#ExternalFileAccess = None
#UdfAccess = Restrict UDF
#TempDirectories =
#LegacyHash = 1
#Authentication = native
#AuditTraceConfigFile =
#MaxUserTraceLogSize = 10
#DatabaseGrowthIncrement = 134217728
#FileSystemCacheThreshold = 65536
#FileSystemCacheSize = 0
#RemoteFileOpenAbility = 0
#CompleteBooleanEvaluation = 0
#DeadlockTimeout = 10
#MaxUnflushedWrites = 100
#MaxUnflushedWriteTime = 5
#BugcheckAbort = 0
#OldColumnNaming = 0
#OldSetClauseSemantics = 0
#RelaxedAliasChecking = 0
#ConnectionTimeout = 180
#DummyPacketInterval = 0
#RemoteServiceName = gds_db
#RemoteServicePort = 3050
#RemoteAuxPort = 0
#TcpRemoteBufferSize = 8192
#TcpNoNagle = 1
#RemoteBindAddress =
#LockGrantOrder = 1
#LockAcquireSpins = 0
#EventMemSize = 65536
#CpuAffinityMask = 1
#UsePriorityScheduler = 1
#PrioritySwitchDelay = 100
#PriorityBoost = 5
#GCPolicy = combined
#GuardianOption = 1
#ProcessPriorityLevel = 0
#IpcName = FIREBIRD
#RemotePipeName = interbas
#Redirection = 0
