Slow SqlCeReplication

[Steve B.]

Hi,

I have an application that use SqlCeMerge replication to transfer data
between mobile devices and a central office server.

With the CF 1.0 and Sql Ce 2.0, the replication took only 30 seconds for a
"send only" replication, with few lines (near 100 rows).

Now with the CF 2.0 and Sql Mobile 3.0, it takes up to 4 minutes to transfer
the data, even if no lines have to be transfered.

The code is quite classic, and I can't see what can be wrong...

Thanks,
Steve

 

[Guest]

Steve,
Do an MSDN search on "merge replication performance" and you will find
enough articals on merge replication performance to choke a billy goat.

I recently completed a project using merge rep and performance seemed most
greatly affected by 2 things;

1) Its critical to use absolutely the cleanest transactional SQL that you
can write. Get into the query analyzer and time your statements. If they
take more than a few milliseconds to run you need to clean them up. If your
not espically good at writing transactional SQL find someone who is to give
you a hand.

2) Fast servers required. We recently got a new development server that I
used for the project. I got performance down to about 8-10 seconds to
transfer 20 tables with maybe 50 rows in each. We deployed to an older slower
server in the production environment and were shocked to see performance
degrade to about 30 seconds for the same transfer. We are currently slated
to get a new production server before the app goes live.

Bill