Supercharging FirebirdSQL

From eStream Software
Revision as of 09:17, 22 June 2017 by Twfaung (talk | contribs) (→‎Steps)

Introduction

By Default firebird will not fully utilise the available RAM. Below is the how to Supercharging the FirebirdSQL so that

01. Fully utilise the available RAM
02. Improve performance

Requirement

  • 64 bit Firebird Server
  • Minimum 16 GB & above RAM

Steps

01. Browse to Firebird folder (Normally in C:\Program Files\Firebird\Firebird_3_0 for Firebird 3) & look for firebird.conf file
02. Copy to Desktop.
03. Open the firebird.conf at Desktop
04. Look for #DefaultDbCachePages = 2048
05. Remove the # and change the 2048 to 150000 for 16 GB RAM

See also