Performance issues with log-based replication

Sybase replication technology is log-based. Modifications performed on replicated tables are logged in the database transaction log. Adaptive Server generates a log record for each modification to each affected row; a single DML statement may result in Adaptive Server generating multiple log records. Depending on the type of DML statement, the Adaptive Server may log one “before” image and one “after” image for every affected row. The Sybase Replication Agent reads the log and forwards it to the Replication Server. The Replication Server identifies the DML operation (insert, delete, update, insert, select, or stored procedure execution) and generates the corresponding SQL statement for every operation.

Log-based replication has these inherent issues:

There are two different approaches to address all of these issues: