Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 merge is slow

Author  Topic 

influent
Constraint Violating Yak Guru

367 Posts

Posted - 2004-09-29 : 14:36:19
I set up Merge Replication for my first time yesterday, and it's working great, except for the speed. One tiny little update takes at least fifteen seconds to show up in the subscriber, and were talking tables with less than 1000 rows and a server with dual 800 Mhz processors. Is that normal?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-09-29 : 18:16:20
Yes it's normal. You can speed it up by changing the profiles.

Tara
Go to Top of Page
   

- Advertisement -