In normal replication, when Replication Server replicates data to Adaptive Server, Replication Server forms a SQL insert command, sends the command to Adaptive Server, and waits for Adaptive Server to process the row and send back the result of the operation. This process affects Replication Server performance when large batches of data are being replicated, such as in end-of-day batch processing or trade consolidation.
Replication Server version 15.2 introduces support for bulk copy-in to improve performance when replicating large batches of insert statements on the same table in Adaptive Server® Enterprise 12.0 and later. Replication Server implements bulk copy-in in Data Server Interface (DSI), the Replication Server module responsible for sending transactions to replicate databases, using the Open Client™ Open Server™ Bulk-Library.
Bulk copy-in is supported for Adaptive Server databases
only. If you turn on DSI bulk
copy-in and the replicate database is not Adaptive Server, DSI shuts down with an error.
For information about the Open Client Open Server Bulk-Library, see the Open Client and Open Server Common Libraries Reference Manual.
