| TRANSACTION ABORT | Index Level | TRANSACTION COMMIT |
| Syntax | TRANSACTION CACHE [ON | OFF | expression] |
| Category | BASIC |
| Type | Statement |
| Description |
enables or disables the transaction read cache.
Normally, all read operations within a transaction first query the list of uncommitted updates. This is to allow the re-reading of an item already written. Users can turn this cache off if they are confident that the transaction does not attempt this activity. Turning the cache off can improve the performance of reads within a transaction especially if that transaction is a long one. |
| Options | |
| See Also | BEGIN WORK |
| Example | |
| Warnings | Once the cache is turned off, it remains off until the program completes. |
| Compatibility | D3 7.0 |
| TRANSACTION ABORT | Index Level | TRANSACTION COMMIT |