(→Steps) |
(→Steps) |
||
| Line 29: | Line 29: | ||
! Function !! Description | ! Function !! Description | ||
|- | |- | ||
| | | 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. | ||
| Line 36: | Line 36: | ||
* 16 (Default) | * 16 (Default) | ||
|} | |} | ||
:05. Enter the Size you wanted or | :05. Enter the Size you wanted or Click <span style="color:#0000ff">Use recommended page buffers setting</span> | ||
:06. Click OK | :06. Click OK | ||
<div style="float: right;"> [[#top|[top]]]</div> | <div style="float: right;"> [[#top|[top]]]</div> | ||
Revision as of 03:17, 14 September 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