Supercharging FirebirdSQL: Difference between revisions

Revision as of 09:23, 22 June 2017

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

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 #

06. Change the 2048 to 150000 for 16 GB 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 9: / Line 9: @@
 ==Steps==
-:01. Browse to Firebird folder (Normally in ''C:\Program Files\Firebird\Firebird_3_0'' for Firebird 3) & look for '''firebird.conf''' file
+:01. Browse to Firebird folder (Normally in ''C:\Program Files\Firebird\Firebird_3_0'' for Firebird 3) & look for <span style="color:#0000ff">firebird.conf</span> file.
 :02. Copy to Desktop.
-:03. Open the firebird.conf at Desktop
+:03. Open the <span style="color:#0000ff">firebird.conf</span> at Desktop
-:04. Look for '''#DefaultDbCachePages = 2048'''
+:04. Look for <span style="color:red">#DefaultDbCachePages = 2048</span>
-:05. Remove the <span style="color:green">#</span> and change the <span style="color:green">2048</span> to <span style="color:#0000ff">150000</span> for 16 GB RAM
+:05. Remove the <span style="color:green">#</span>
+:06. Change the <span style="color:green">2048</span> to <span style="color:#0000ff">150000</span> for 16 GB 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]]