This forum is closed. Thank you for your contributions.

Sign in

Microsoft.com

Microsoft

Remove From My Forums

Sync Framework SLOW using WCF Service?

Question
0

Sign in to vote

We've implemented Sync Framework for a client. WPF applications uisng SQLCE LocalDataCache, WCF Sync Service, SQL 2008 R2 central database. When connected directly to the database, sync happens quickly. When using a WCF Sync Service the sync trace shows that the delay is happening here:

INFO , MYAPPLICATION.vshost, 15, 03/21/2012 17:10:52:554, --- End Client Enumerating Changes to Server for Group "LocalDataCacheGlobalSyncGroup" ---
INFO , MYAPPLICATION.vshost, 15, 03/21/2012 17:15:11:677, ----- Client Applying Changes from Server for Group "LocalDataCacheGlobalSyncGroup" -----

I'm not sure what's going on between these two steps in the process. All prior and post Sync Stages happen in a matter of < 3 seconds. The sync does complete, just takes so long it is unacceptable for the clients needs as they will need to sync 10 - 20 times the data which takes > 30 minutes.

I appreciate any suggestions and direction. Thank you much!

Chuck

Wednesday, March 21, 2012 5:54 PM

All replies

0

Sign in to vote

try this, the concept should apply even if youre not using a mobile device:

Synchronization Services for ADO .NET for Devices: Improving performance by skipping tables that don’t need synchronization

if you have plenty of changes, you may try the DataSetSurrogate approach

Sync Framework WCF-based Synchronization for Offline scenario – Using custom dataset serialization

Wednesday, March 21, 2012 11:55 PM
0

Sign in to vote

Thank you for the suggestions! I'll take a look. I just wanted to follow up and mention that by using Fiddler I was able to determine that the Remote Provider (Sync Service) returned the expected 10 MB of data within seconds after the Synchronization was started. Then nothing after that from Fiddler as I now had my data with the response. The huge delay is after that and before Client Applying Changes from Server for Group. So definitely something is going on with the client that is taking (this last time) nearly 15 minutes to start the Applying Changes Sync Stage.

Again, thanks for the recommended reading!

Thursday, March 22, 2012 6:14 PM