Supercharging FirebirdSQL: Difference between revisions

From eStream Software
 
(One intermediate revision by the same user not shown)
Line 14: Line 14:
:04. Look for <span style="color:red">#DefaultDbCachePages = 2048</span>.
:04. Look for <span style="color:red">#DefaultDbCachePages = 2048</span>.
:05. Remove the <span style="color:green">#</span> .
: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.
: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.
:07. Save the file.
:08. Copy the <span style="color:#0000ff">firebird.conf</span> at Desktop.
: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.
:09. Paste & Replace it in the Firebird folder  <span style="color:#0000ff">firebird.conf</span> file.
:10. Restart the Server.
:10. Restart the Server.
<br />
{| style="margin: 1em auto 1em auto;"
|-
|
----------------------------------------------------------------------------------------------------------------------------------------------------
{|
|-
| [[File:Template.Tips-01.jpg|60px]]|| Can Download below file & direct jump to '''Steps 9'''
|}
----------------------------------------------------------------------------------------------------------------------------------------------------
|}
* [http://www.estream.com.my/downloadfile/Fairy/firebird-16GB.zip Firebird Configuration file - 16 GB RAM]
* [http://www.estream.com.my/downloadfile/Fairy/firebird-32GB.zip Firebird Configuration file - 32 GB RAM]


==See also==
==See also==
* Others [[Customisation]]
* Others [[Customisation]]

Latest revision as of 08:35, 14 October 2022

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