Performance Enhancements for Adaptive Server Replication

Replication Server provides several features that enhance performance for Adaptive Server replication.

• SQL Statement Replication – Replication Server supports SQL statement replication in Adaptive Server which complements log-based replication and addresses performance degradation caused by batch jobs. Sybase recommends that you use SQL statement replication when:
  • DML (data manipulation language) statements affect a large number of rows on replicated tables.
  • You have difficulty altering the underlying application to enable stored procedure replication.
• High Volume Adaptive Replication – Replication Server includes High Volume Adaptive Replication (HVAR) to enhance performance for replication to Adaptive Server.

  HVAR compiles and combines a larger number of transactions into a group, improving bulk operation processing. Therefore, replication throughput and performance also improves.

  HVAR is especially useful for creating online transaction processing (OLTP) archiving and reporting systems where the replicate databases have the same schemas as the primary databases.

See Replication Server Administration Guide Volume 2 > Performance Tuning > SQL Statement Replication and Replication Server Administration Guide Volume 2 > Performance Tuning > Advanced Services Option > High Volume Adaptive Replicationn.