Be sure to place the master database server on a machine that has the best possible network throughput. Carefully estimate and test the maximum amount of data transferred during synchronization to ensure that the bandwidth of the network is sufficient for database synchronization.
Be sure to test the network for transmission of the synchronization messages. These messages contain:
▪ Header data (insignificant).
▪ Transactions, which include:
– procedure calls as strings,
– parameters as binary data.
▪ Refreshes to publications, which include:
– all inserted and updated rows from the master database,
– primary keys of rows that are deleted from the master database.