Start/notes.ini Parameters/TRANSLOG_Performance

TRANSLOG_Performance

🛠️
Parameter: TRANSLOG_Performance
Short description: Performance / recovery mode of the transaction log (balance between write throughput and crash recovery time).

Profile

Parameter
TRANSLOG_Performance
Category
Transaction log
Component
Server
Available since
R5
Supported versions
9.0.1, 10.0, 11.0, 12.0, 14.0, 14.5
GUI equivalent
Server document (Transactional Logging)
Possible values
1 = Favor Runtime (best performance), 2 = Standard, 3 = Favor Recovery Time (fastest recovery)

Description

TRANSLOG_Performance adjusts the trade-off between runtime performance and recovery speed of the transaction log:
  • 1 – Favor Runtime: maximum write performance; longer recovery time in case of a crash.
  • 2 – Standard: default; balanced.
  • 3 – Favor Recovery Time: recovery runs faster, in exchange for a slight performance loss in normal operation.
For high-throughput mail and application servers, 1 is suitable; for cluster mates or critical production systems with tight RTO targets, 3.

Example configuration

TRANSLOG_Performance=1

Notes & pitfalls

  • The value is only effective when transaction logging is actually active (TRANSLOG_Status=1).
  • Combines with TRANSLOG_Style, TRANSLOG_Path, TRANSLOG_MaxSize.
  • Recommended: a fast, local SSD path for TRANSLOG_Path.
  • Recovery time can range from several minutes to hours depending on data volume – document RTO upfront.
  • The change only takes effect after a server restart.