RTL tries to group as many compilable transactions as possible together, compiles the transactions in the group into a net change, and then uses the bulk interface in the replicate database to apply the net changes to the replicate database.
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.
RTL improves performance for replication to Sybase IQ compared to the continuous replication mode and a staging solution for example, because of the:
Reduced number of external components – leads to reduced maintenance costs and overheads since there is no requirement for the staging database.
Reduced latency – without the overhead from the staging solution and with replication directly into Sybase IQ.
Improved usability – the RTL configuration is straightforward and does not require function string mapping, DSI suspend and resume, data population from staging database to Sybase IQ, and the scheduling activities required for the staging solution.
Improved replication performance – instead of sending every logged operation, RTL compilation removes the intermediate insert, update, or update 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 a much smaller amount of data is processed.
See “RTL compilation and bulk apply,” for more information on RTL processing.
Replication to Sybase IQ using real-time loading is available in the Replication Server – Real-Time Loading Edition product edition. See “Replication Server 15.5 licensing,” in Chapter 1, “New Features in Replication Server Version 15.5” in the Replication Server 15.5 New Features Guide.
To activate RTL, you must download the Replication Server – Real-Time Loading Edition product edition license from the Sybase Product Download Center (SPDC), to which you are automatically enrolled in when you purchase a Sybase product. Log in to SPDC by using the information in your SPDC welcome e-mail. Contact your Sybase representative for more information.
If you have purchased your Sybase software from a Sybase
reseller, you will receive a Web key rather than an e-mail message.
For information about licensing and Sybase Software Asset Management (SySAM), see the Sybase Software Asset Management Users Guide.
RTL supports replication into Sybase IQ 12.7 ESD #3 and later.
Replication Server supports replication to Sybase IQ only from Adaptive Server version 15.0.3 or version 15.5 and later as the primary database.
You can achieve optimal performance using 64-bit hardware platforms. See “64-bit support,” in the Replication Server 15.5 New Features Guide.
