开发者

Slow SQL Sync with Microsoft Sync Framework on Mobile Client

开发者 https://www.devze.com 2022-12-29 18:00 出处:网络
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 mi

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.


I have the same problem. The sync time improves dramatically if you change the batch size.I trid the following hot fix. http://support.microsoft.com/kb/973058 I did'nt see any improvements.

0

精彩评论

暂无评论...
验证码 换一张
取 消