Changes to subscription materialization

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.

NoteIn 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.

For more information about subscription materialization, see Replication Server Administration Guide Volume 1.