(Created page with "==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 :...") |
(→Steps) |
||
| (9 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
==Introduction== | ==Introduction== | ||
By Default firebird will not fully utilise the available RAM. Below is the how to Supercharging the FirebirdSQL so that | 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 | :02. Improve performance | ||
==Requirement== | ==Requirement== | ||
* Firebird Server | * 64 bit Firebird Server | ||
* Minimum 16 GB & above RAM | * Minimum 16 GB & above RAM | ||
==Steps== | ==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== | ==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
- Others Customisation