(→Steps) |
(→Steps) |
||
| Line 30: | Line 30: | ||
---------------------------------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- | ||
|} | |} | ||
[http://www.estream.com.my/downloadfile/Fairy/firebird-16GB.zip Firebird Configuration file - 16 GB RAM] | * [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] | * [http://www.estream.com.my/downloadfile/Fairy/firebird-32GB.zip Firebird Configuration file - 32 GB RAM] | ||
==See also== | ==See also== | ||
* Others [[Customisation]] | * Others [[Customisation]] | ||
Revision as of 10:05, 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).
- 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 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.
|
See also
- Others Customisation