Keep in mind that merge replication is expected to have some latency. If you
need concurrent data, and 1 second sounds like you do, consider using
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.
"Rogers" <Rogers (AT) discussions (DOT) microsoft.com> wrote
"Pascal Deliot" wrote:
As far as remember, continuous mode means "run the merge each 5 seconds".
After that, you must add the time taken by each merge process that can be
long depending on the load, the retention period, the use of filters...
Then no, 1 seconds can't be a reasonable target.
"Rogers" <Rogers (AT) discussions (DOT) microsoft.com> a écrit dans le message de
news:8C660BB3-E7DF-40A6-8D3F-5ED1CB9B2B96 (AT) microsoft (DOT) com...
I created Merge Replication (Push Data: Run Continuesly) into two
boxes and it takes around 15-20 seconds to merge into Subscriber.
Is it normal? or we can do configuration to replicate if 1 second?