core:Properties

From eStream Software
Revision as of 03:17, 14 September 2017 by Twfaung (talk | contribs) (→‎Steps)

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
Core.Others.Properties.jpg
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.
  • Untick - The operating system controls when the data is actually written to disc.
Page Buffers (in MB)
  • 16 (Default)
05. Enter the Size you wanted or Click Use recommended page buffers setting
06. Click OK