core:Properties: Difference between revisions

From eStream Software
No edit summary
No edit summary
Line 40: Line 40:
<div style="float: right;">  [[#top|[top]]]</div>
<div style="float: right;">  [[#top|[top]]]</div>


  TIPS:
  '''TIPS:'''
  Things to take note when you have '''untick - Write data to hard disc immediately''':
  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).
  a. Server PC must protected by '''a reliable UPS''' (ie. backup power battery).
  b. Make sure the '''server shutdown tidily'''.
  b. Make sure the '''server shutdown tidily'''.
  c. Operating System must at least minimum is''' Win7, Windows Server 2012 and above'''.
  c. Operating System must at least minimum is''' Win7, Windows Server 2012 and above'''.

Revision as of 04:04, 16 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
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.