Value | Effect | Synonyms |
---|---|---|
yes | Turns on transaction support. This is the default value. | y, true, on, 1 |
no | Turns off transaction support. | n, false, off, 0 |
Attribute | Description | Defalt value |
---|---|---|
logging | Enable/disable transaction logging. Values: "yes" : Turns on transaction logging. It is indicated when data safety is more important than performance. Files are created with c-tree file mode ctTRNLOG and are automatically recovered after a crash. "no" : Turns off transaction logging. It is indicated when performance is more important than data safety. Files are created with c-tree file mode ctPREIMG. This is the default value. | no |
fileoperations (or fileops) | Determines whether file operations (such as file create, delete, and rename) performed within an active transaction are affected by the transaction ending operation (commit or abort): "yes" : File operations are transaction dependent. "no" : File operations performed within an active transaction are not affected by the transaction ending operation (commit or abort). | no |
deferautocommit | Turn on optimization that improves performance for functions that use autocommit. Similar to the c-tree DELAYED_DURABILITY keyword, guarantees atomicity and consistency of transaction but not durability because the last transaction could be lost. | no |
<transaction logging="no">yes</transaction> |