# Configuration file for Firebird 2.5 32-bit SuperServer, by IBSurgeon (www.ib-aid.com), released March 23, 2020 # This is an optimized configuration for Firebird 2.5 SuperServer 32 bit, 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 19 total connections for all databases ############## and less than 4Gb of RAM, don't use this configuration! #### For higher load use SuperClassic or Classic! ####################################################################### ########### 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 = 9999 TempBlockSize = 2048576 TempCacheLimit = 367108864 FileSystemCacheThreshold = 655360 LockMemSize = 5048576 LockHashSlots = 20011 #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 = #LockMemSize = 1048576 #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