DML Best Practices

Best practices will improve performance with batch loads and large updates.

For batch loads:

• Perform small- or medium-sized concurrent loads through the RLV store.
• Do not perform excessively large loads through the RLV store, because loads exceeding maximum RLV memory may fail.

Even if a very large load does not exceed the maximum RLV memory (and does not fail), merges of other committed RLV data may be triggered during the load. This may impact load performance.

For large updates:

• Perform large updates on RLV-enabled tables with a table-level versioned connection.
• Do not perform very large updates through the RLV store because updates copy on-disk rows to the RLV in-memory store for modification.