Bulk copy-in also improves 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.
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.
See “dsi_bulk_copy,” and “dsi_bulk_threshold,” in “Table 7-1,” for more information.
