question

DavidK avatar image
DavidK asked

Speed issues with Merge Replication

I have some clients using Merge Replication. They may not replicate for a few days at a time which could result in thousands of Updates & Inserts been needed. This could be any thing from 100,000 to 500,000 records.Needless to say this can take a long time , and more often than not will fail. Is there anything I can do to help the situation and improve performance ? Is it worth looking at Web Synchronization - would this be quicker or slower ? Ant thoughts would be appreciated.
replicationmerge-replication
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sjimmo avatar image sjimmo commented ·
Please describe further your replication system, as well as number of databases being replicated with number of publications and subscribers. Please also provide information about your distributor.
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.