Supercharging FirebirdSQL

From eStream Software
Revision as of 08:35, 14 October 2022 by Twfaung (talk | contribs) (→‎Steps)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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 (about 90% depend how big is the FDB size & number of FDB connected)
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).
02. Look for firebird.conf file & copy to Desktop.
03. Open the firebird.conf at Desktop.
04. Look for #DefaultDbCachePages = 2048.
05. Remove the # .
06. Change the 2048 to 1000000 for 16 GB RAM. (will use 8GB RAM)
07. Save the file.
08. Copy the firebird.conf at Desktop.
09. Paste & Replace it in the Firebird folder firebird.conf file.
10. Restart the Server.

See also