| TRANSACTION COMMIT | Index Level | TRANSACTION ROLLBACK |
| Syntax | TRANSACTION FLUSH [ON | OFF | expression] |
| Category | BASIC |
| Type | Statement |
| Description |
enables or disables the transaction flush mechanism.
Normally, all updates processed within a transaction are force-flushed to a reliable medium (disk). This is done to assure ACID compliance - i.e. the ability to recover a transaction if the machine should halt unexpectedly. If ACID ("Atomic", "Compliant", "Isolated", Durable") compliance is not necessary, then this flush mechanism can be disabled providing signicantly higher performance. |
| Options | |
| See Also | BEGIN WORK |
| Example | |
| Warnings |
Once the flush is turned off, it remains off until the program completes.
If the flush is disabled, and the machine halts, all pending transactions are aborted in a potentially semi-committed state. |
| Compatibility | D3 7.0 |
| TRANSACTION COMMIT | Index Level | TRANSACTION ROLLBACK |