Real-Time Loading Solution

RTL groups as many compilable transactions as possible, compiles the transactions in the group into a net change, and then uses the bulk interface in the replicate database to apply the net change to the replicate database.

When replicating into Sybase IQ replicate databases, RTL uses:

Compilation – rearranges replicate data by each table, and each insert, update, and delete operation, and 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 then applies to the replicate database.

RTL improves performance for replication to Sybase IQ compared to the continuous replication mode and a staging solution for example, by using:

Reduced number of external components – reduced maintenance costs and overhead, since there is no requirement for the staging database.
Reduced latency – no overhead from the staging solution and with replication directly into Sybase IQ.
Improved usability – the RTL configuration does not require any of: function-string mapping, DSI suspend and resume, data population from staging database to Sybase IQ, scheduling activities for the staging solution.
Compilation and bulk apply – instead of sending every logged operation, compilation removes the intermediate insert, update, or delete operations in a group of operations and sends only the final compiled state of a replicated transaction. Depending on the transaction profile, this generally means that Replication Server sends a smaller number of commands to Sybase IQ to process.

Sybase IQ provides a bulk interface that improves insert operation performance compared with the SQL language mode operation. RTL takes advantage of the Sybase IQ bulk interface to improve performance for insert as well as update and delete operations.

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 adjust group sizes to control the amount of data that is grouped together for bulk apply.

License

Replication to Sybase IQ using real-time loading is available in the Real-Time Loading Edition product edition. See Replication Server Installation Guide > Planning Your Installation > Obtaining a License.

Database and Platform Support

Sybase IQ – you can use real-time loading to replicate into Sybase IQ version 12.7 ESD #3 and later. See Replication Server Release Bulletin > Product Compatibility > Replication Server Interoperability for the latest supported Sybase IQ versions and platforms.
Adaptive Server – Replication Server supports replication to Sybase IQ from Adaptive Server version 15.0.3 or version 15.5 and later.
Oracle – Replication Server supports replication to Sybase IQ from Oracle 10g and 11g. See Replication Server Options 15.5 > Release Bulletin Replication Agent 15.5 > Product Summary > Compatible Products.

64-bit Support

You can achieve optimal performance using 64-bit hardware platforms. See Replication Server New Features Guide > New Features in Replication Server Version 15.5 > Support for 64-bit Computing Platforms.