Sybase IQ replication using real-time loading (RTL) improves performance and is available as a Replication Server – Real-Time Loading Edition feature.
In versions earlier than 15.5, Replication Server sends each replication operation to the replicate database directly, row-by-row and in log order in a continuous replication mode.
Replication Server version 15.5 and later allows you to replicate to Sybase IQ from Adaptive Server using real-time loading. When replicating into Sybase IQ replicate databases with identical database schema, Replication Server achieves better performance than with the continuous replication mode. RTL uses these processes, which result in data reduction:
Compilation – rearranges replicate data, by clustering it by each table, and each insert, update, and delete operation, and then compiling the operations into net-row operations.
Bulk apply – applies the net result of the compilation operations in bulk using the most efficient bulk interface for the net result. Replication Server uses an in-memory net-change database to store the net row changes which it applies to the replicate database.
Instead of sending every logged operation, compilation removes all the intermediate operations and sends only the final states of a replicated transaction. Depending on the application, this generally means a much smaller amount of data is processed.
As Replication Server compiles and combines a larger number of transactions into a group, bulk operation processing improves; therefore, replication throughput and performance also improves.You can control the amount of data that is grouped together for bulk apply by adjusting group sizes.
See Replication Server Heterogeneous Replication Guide > Sybase IQ as Replicate Data Server.
Replication to Sybase IQ using RTL is available in the Real-Time Loading Edition product edition.
You can use RTL to replicate into Sybase IQ 12.7 ESD #3 and later. You can achieve optimal performance using 64-bit hardware platforms.
Replication Server 15.5 supports replication to Sybase IQ only from Adaptive Server version 15.0.3 or version 15.5 and later as the primary database.