Re: Merge Performance

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Oops sorry man.

Some folks build local sdf and then ftp it to the pda to get around this.

Can you perhaps email me offline and I'll have a quick look at your topology
and see if I can figure out what is going on and escalate it to Microsoft if
necessary.

Use the gmail address I post from.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Jon" <Jon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D2C1E1E9-12ED-413D-8F87-98D201C51478@xxxxxxxxxxxxxxxx
Bump for response.

"Jon" wrote:

Hilary,

Because of the large database size on the PDA (about 61mb), initial syncs
take 30 minutes (although the new device has reduced that time to about
20
mins). I'm not really sure what else we can do to reduce that time. The
bulk of the time appears to be a result of applying a massive amount of
rows
on such a small device.

Another question, I noticed that the recgen is very behind the sentgen
for
all subscribers, even those who have synced recently, successfully. Is
this
normal?

Thanks,

Jon

"Hilary Cotter" wrote:

Generally the more shallow the joins the better performance. Make sure
you
have indexes on the filters as well.

Set the retention period to something small to minimize your sync
times.

There is something very wrong with taking 30 minutes to initialize a
subscriber. Do you generate your snapshot frequently?

--
RelevantNoise.com - dedicated to mining blogs for business
intelligence.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Jon" <Jon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5B8C3206-A33D-4DA8-97F7-AAD182215951@xxxxxxxxxxxxxxxx
Scenario:
I work for a company that is implementing a large-scale disconnected
PDA
application. We are using merge replication. We have 204 articles,
about
100 of which are bidirectional. Of these 100, about 50 are filtered
using
joins. Currently, partitioned snapshots take about 2 minutes each to
complete. The initial database size is about 50mb and takes about 30
minutes
to initialize a subscriber. After this, syncs are generally fast,
taking
about 2 minutes to complete hundreds of rows.

Questions:
1.) What can we do to improve performance of the filters?
2.) Sometimes generation evaluation can cause follow-up syncs to take
5-10X
longer. Any ideas why?

Thanks in advance.





.

Relevant Pages

  • Re: Merge Performance
    ... Looking for a SQL Server replication book? ... to initialize a subscriber. ... What can we do to improve performance of the filters? ... Sometimes generation evaluation can cause follow-up syncs to take ...
    (microsoft.public.sqlserver.replication)
  • Re: Overlapping or nonoverlapping publication? Which type applies to my design?
    ... will remain in the subscriber and never move to the publisher. ... Should a salesman take on new clients, the partition will have the new ... replicated to the PDA. ... Mobile users cannot modify or delete data. ...
    (microsoft.public.sqlserver.replication)
  • Re: Cant sync contacts with my PDA or add or delete contacts in Outlook
    ... I checked the firewall and the exceptions are ... Activesync and remote access. ... everything I modify never syncs with the PDA. ...
    (microsoft.public.pocketpc)
  • Re: Palm Tungsten E vs PockePC Dell Axim
    ... > Syncs Email, Calendar, Tasks, Contacts, and Notes with ... > Outlook/Exchange ... just a simple PDA that syncs with Outlook with Email ...
    (microsoft.public.pocketpc)
  • Re: more electoral defeats for the feudalists
    ... circumstances where a PDA would necessarily _not_ do so. ... PDA1 considers the playing of loud ... music after 10 PM on a weekday to be a crime, PDA2 does not. ... PDA1 subscriber; ...
    (sci.econ)