Optimize Synchronization

Replication Wizard Help

Replication Wizard Help

Optimize Synchronization

Optimizing synchronization during merge replication allows you to minimize network traffic when determining if recent changes have caused a row to move into or out of a partition for a Subscriber. In merge replication, an option is provided that stores more information at the Publisher instead of transferring that information over the network to the Subscriber. While this option may result in a larger database at the Publisher, it can improve synchronization performance by making filter evaluation more efficient and minimizing network traffic over a slow link. However, more information will be stored at the Publisher and additional storage space will be necessary.

If the optimize synchronization setting is not used, changes in one partition will cause the merge process to verify the partition content of data sent to all Subscribers again, even if the change affects only one or a few Subscribers.

Select Yes, minimize the amount of data if you want to store more information at the Publisher instead of sending it over the network to the Subscriber.

Select No, do not minimize the amount of data if you want the information to be sent over the network to the Subscriber.

See Also

Optimizing Synchronization