Performance Implications of Table-Level Snapshot Versioning

Typically, table-level snapshot versioning has a minimal impact on performance.

However, there are certain resource issues you should be aware of:

Delays due to locking are minimal. Individual commits, rollbacks, and checkpoints might block other read or write transactions, but only very briefly.

All of these performance and disk use factors only affect your system in the degree to which you take advantage of the SAP Sybase IQ concurrent read and write capabilities. Disk space requirements in particular can vary widely, depending on how long write transactions take before they commit, how many read transactions take place during write transactions, the number of rows these transactions affect, and whether you allow the release of data pages at interim savepoints.