|
|
|
A significant performance gain can be obtained in some situations by avoiding transaction logging of files, thereby foregoing the protection of recovery. With FairCom DB it is possible to maintain atomicity of transactions in this state with a transaction mode of ctPREIMG. This support is also extended to FairCom DB SQL Tables when they are created.
An additional option has been added to theFairCom DB SQL keyword STORAGE_ATTRIBUTES.
STORAGE_ATTRIUBUTES 'PREIMG'
This option disables transaction logging for the table. This can be useful for temporary tables that are not required to be recovered in the event of catastrophic failure, yet retain atomicity of transactions.
To combine STORAGE_ATTRIBUTE options, separate them with a semicolon (;). For example, to create a non-HUGE, PREIMAGE table, you would issue a statement such as the following.
non-HUGE PREIMAGE Example
CREATE TABLE small_preimage_table (name CHAR(10), age SMALLINT) STORAGE_ATTRIBUTES 'NONHUGE;PREIMG'
