Logging for DML Commands

Because logging database activities is expensive and can negatively impact the RAPCache database's performance, the database can perform minimal to no logging as it executes some data manipulation language (DML) commands on low-durability databases.

The DML commands include insert, update, delete, and slow bcp (for example, bulk inserts), and can be executed on all types of low-durability databases, such as in-memory and reduced-durability databases, that use the at_shutdown and no_recovery options. You can perform minimal logging for DMLs on a per-database, per-table, and session-specific basis. Performing minimal logging for DMLs on a per-database level can drastically improve the performance of the RAPCache database.

See the Adaptive Server Enterprise In-Memory Database Users Guide and Adaptive Server Enterprise Performance and Tuning Series: Basics.