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.
| Author |
Topic |
|
iumerkhan84
Starting Member
1 Post |
 Posted - 2007-11-05 : 06:21:02
|
| Currently database1 and database2 are planned to be synchronized with the interval of 5 seconds!! ( dont know exact, but i select run continoulsly on subscriber screen )This could cause serious performance issues as both applications will be live on difference servers.how can i Synchronization should be performed on day basis or it should be modification basis to avoid any performance issue on live applicationi am using merge replicationLocal distributorand subscriber on another server .plz help meits urgent |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-11-05 : 06:30:36
|
| Does it matter that much?if its going to replicate, say, 100MB a day does it matter if it does a little every few seconds, or all at once once-a-day?Kristen |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-05 : 22:05:20
|
| It also depends on business requirement. If user needs local and replicated data on the server in real time, you have no choice. |
|
|
|
dirtydavey
Yak Posting Veteran
80 Posts |
Posted - 2007-11-06 : 11:36:50
|
| Not sure what the point of having merge replication is if you dont let it sync! |
|
|
|
|
|
|
Synchronization performed on day basis