(→Steps) |
|||
Line 9: | Line 9: | ||
==Steps== | ==Steps== | ||
: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 <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 | |||
==See also== | ==See also== | ||
* Others [[Customisation]] | * Others [[Customisation]] |
Revision as of 09:17, 22 June 2017
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
- 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) & look for firebird.conf file
- 02. Copy to Desktop.
- 03. Open the firebird.conf at Desktop
- 04. Look for #DefaultDbCachePages = 2048
- 05. Remove the # and change the 2048 to 150000 for 16 GB RAM
See also
- Others Customisation