Slow SQL Sync with Microsoft Sync Framework on Mobile Client
- by Malkier
Hello,
we are developing an application which uses MS Sync Framework to sync data between Windows CE 6.0 with SQL CE 3.5 SP1 Clients and an SQL 2008 Database. Our major problem is a slow sync time up to 1 minute for 15 tables which are totally empty.
Here's a break down of our components:
Server:
Sql Server 2008
15 tables with activated change tracking
WCF Service with endpoint for the mobile sync (uses Sync Framework 2.0)
Client (Mobile)
Windows CE 6.0
NET Application using Sync Framework for Devices (CTP 1) which starts the sync
As I mentioned above, the sync takes up to 1 minute without any changes and empty tables. The mobile device is in its dock.
This is a deal breaker for a production environment. Does anybody have any experience in this field? Is there a way to improve things?
Thanks for any responses.