Product Documentation

Database Administrator's Guide

Previous Topic

Next Topic

Transaction Processing

Transaction Processing

Transaction control is an important consideration when optimizing between recoverability and performance. When properly configured, transaction processing can ensure recoverability with a minimum impact on performance. If transaction processing is ignored, you can be leaving your data vulnerable to loss in the case of a server failure or hardware failure.

Three different levels of FairCom DB transaction processing can be implemented. Each level offers different features and benefits. In particular, each level has a different trade-off between speed and recoverability:

 

Full Transaction Processing

 

Full TranProc Speed/Recover

 

 

PreImage Transaction Processing

 

PreImage TranProc Speed/Recover

 

 

No Transaction Processing

 

No TranProc Speed/Recover 

In This Chapter

Full Transaction Processing

PreImage Transaction Processing

No Transaction Processing

Flushing Log Files to Disk

Properties of Cached Files

WRITETHRU Files

TOCIndex