Supercharging FirebirdSQL: Difference between revisions

Latest revision as of 08:35, 14 October 2022

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

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.

@@ Line 1: / Line 1: @@
 ==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
+:01. Fully utilise the available RAM (about 90% depend how big is the FDB size & number of FDB connected)
 :02. Improve performance
@@ Line 9: / Line 9: @@
 ==Steps==
+:01. Browse to Firebird folder (Normally in ''C:\Program Files\Firebird\Firebird_3_0'' for Firebird 3).
+:02. Look for <span style="color:#0000ff">firebird.conf</span> file & copy to Desktop.
+:03. Open the <span style="color:#0000ff">firebird.conf</span> at Desktop.
+:04. Look for <span style="color:red">#DefaultDbCachePages = 2048</span>.
+:05. Remove the <span style="color:green">#</span> .
+:06. Change the <span style="color:green">2048</span> to <span style="color:#0000ff">1000000</span> for 16 GB RAM. (will use 8GB RAM)
+:07. Save the file.
+:08. Copy the <span style="color:#0000ff">firebird.conf</span> at Desktop.
+:09. Paste & Replace it in the Firebird folder  <span style="color:#0000ff">firebird.conf</span> file.
+:10. Restart the Server.
 ==See also==
 * Others [[Customisation]]