core:Properties

From eStream Software
Revision as of 04:04, 16 October 2017 by Csloo (talk | contribs)

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. (Not Recommended)
Page Buffers (in MB)
  • 16 (Default)
05. Enter the Size you wanted or Click Use recommended page buffers setting
06. Click OK
TIPS:
Things to take note when you have untick - Write data to hard disc immediately:
a. Server PC must protected by a reliable UPS (ie. backup power battery).
b. Make sure the server shutdown tidily.
c. Operating System must at least minimum is Win7, Windows Server 2012 and above.