More Efficient Flushing of Files

By skipping calls to flush operating system buffers and instead writing the files directly to disk, dramatic performance gains can be obtained. The measurable effect of these options is dependent upon the operating system, and other c-tree Server configurations directly impacting specific files (for example, LOGIDX).

Two c-tree Server configuration keywords affect this behavior.

COMPATIBILITY TDATA_WRITETHRU

COMPATIBILITY TINDEX_WRITETHRU

These c-tree Server configuration keywords force transaction controlled data files and index files, respectively, to be written directly to disk; that is, whenever c-tree determines that they must be flushed from the c-tree buffers. Bypassing the OS buffers allows a faster throughput to these files.