Product Documentation

Database Administrator's Guide

Previous Topic

Next Topic

I/O caching

If the computer running the FairCom Server has sufficient memory and the size of the files controlled by the FairCom Server are relatively large, increasing DAT_MEMORY and IDX_MEMORY can potentially improve performance. In general, the larger the data and index cache sizes, the better the performance for high volume environments. The FairCom Server uses a hashed caching algorithm, so there is no need for concern with having the cache sizes set too large.

Background Flush Options

Beginning with V11 additional options allow for advanced tuning for background flush of data and index caches. These apply to both transaction controlled files and non-transaction controlled files. There are two background threads available for class of files resulting in four available threads for optimal flush tuning.

NONTRAN_DATA_FLUSH_SEC

NONTRAN_INDEX_FLUSH_SEC

TRAN_DATA_FLUSH_SEC

TRAN_INDEX_FLUSH_SEC

Unbuffered I/O

FairCom Server also supports use of unbuffered disk I/O operations on a per-file basis. Unbuffered I/O bypasses file system cache and avoids double caching of data in both the FairCom Server and file system cache.

UNBUFFERED_IO

TOCIndex