Bulk Copy-in and Subscription Materialization

Use bulk copy-in to improve the performance of subscription materialization.

When dsi_bulk_copy is on, Replication Server uses bulk copy-in to materialize the subscriptions if the number of insert commands in each transaction exceeds dsi_bulk_threshold.

Note: In normal replication, bulk operation is disabled for a table if autocorrection is on. However, in materialization, bulk operation is applied even when autocorrection is enabled, if dsi_bulk_threshold is reached and the materialization is not a nonatomic subscription recovering from failure.
Related reference
Configuration Parameters Affecting Physical Database Connections