(→Steps) |
(→Steps) |
||
| Line 31: | Line 31: | ||
| Write data to hard disc immediately || | | Write data to hard disc immediately || | ||
* Tick (Default) - This means that data is flushed to disc on COMMIT. This is safest for your data. | * Tick (Default) - This means that data is flushed to disc on COMMIT. This is safest for your data. | ||
* Untick - The operating system controls when the data is actually written to disc. | * Untick - The operating system controls when the data is actually written to disc. (Not Recommended) | ||
|- | |- | ||
| Page Buffers (in MB) || | | Page Buffers (in MB) || | ||
Revision as of 03:43, 2 October 2017
Introduction
By default firebird not fully utilies the RAM. Using this new function user can self allocate size of RAM to be use for each Database.
Pros
- Fully use the available RAM in server
- Increase the database performance
Cons
- Will slow down the Server Performance if not careful
- Not support for Standalone
Requirement
- Available Version :
- SQL Accounting : 746 & above
- SQL Payroll : 130 & above
- Firebird Server
- Minimum 16 GB RAM
Steps
- 01. Click 3 dot button
- 02. Right Click the Database you wanted to set.
- 03. Select Properties
- 04. Enter ADMIN Password
| Function | Description |
|---|---|
| Write data to hard disc immediately |
|
| Page Buffers (in MB) |
|
- 05. Enter the Size you wanted or Click Use recommended page buffers setting
- 06. Click OK