Slow SQL Sync with Microsoft Sync Framework on Mobile Client

Posted by Malkier on Stack Overflow See other posts from Stack Overflow or by Malkier
Published on 2010-05-07T08:26:23Z Indexed on 2010/05/23 3:20 UTC
Read the original article Hit count: 609

Filed under:

windows-mobile

|

sql-server-ce

|

syncframework

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.

© Stack Overflow or respective owner

Related posts about windows-mobile

Adding AJAX Support to Windows Mobile Web Applications

as seen on Internet.com - Search for 'Internet.com'
In this article, you will learn how you can utilize AJAX scripts even in Web applications targeted for Windows Mobile applications. >>> More
Mobile Apps: 50 Best Free Windows Mobile Apps

as seen on Internet.com - Search for 'Internet.com'
These free mobile apps are the "must haves" of the mobile app world. To save you time, we rounded up the very best 50 mobile apps that no Windows mobile user should be without. >>> More
Microsoft UK: Windows Mobile 7 Coming Late in 2010

as seen on Internet.com - Search for 'Internet.com'
The company's new effort to take on the iPhone might not make its appearance for quite some time, if one report is correct. >>> More
When Will Windows Mobile 7 Arrive?

as seen on Internet.com - Search for 'Internet.com'
All eyes are on Barcelona as Microsoft tries to regain its footing in mobile. >>> More
Windows Phone 7 Will Not Run Windows Mobile Apps

as seen on Internet.com - Search for 'Internet.com'
The latest version of Microsoft's mobile operating system will make a clean break with the past. >>> More

Related posts about sql-server-ce

How programically check if SqlServerCe is installer (System.data.sqlserverce exist)

as seen on Stack Overflow - Search for 'Stack Overflow'
How programically check if SqlServerCe is installer (System.data.sqlserverce exist) in c# .Net 3.5. Can I get the version on SqlServerCe? >>> More
How programically check if SQL Server CE is installer (System.data.sqlserverce exist)

as seen on Stack Overflow - Search for 'Stack Overflow'
How can I programmatically check whether SQL Server CE is installed (System.data.sqlserverce exist) in C# .Net 3.5. Can I get the version on SQL Server CE? >>> More
Slow Update/insert into SQL Server CE using LinqToDatasets

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a mobile app that is using LinqToDatasets to update/insert into a SQL Server CE 3.5 File. My Code looks like this: // All the MyClass Updates MyTableAdapter myTableAdapter = new MyTableAdapter(); foreach (MyClassToInsert myClass in updates.MyClassChanges) { // Update the row if it is… >>> More
SQL Server CE, Visual Studio 2008/2010 RC, and Linq-to-Sql

as seen on Stack Overflow - Search for 'Stack Overflow'
I added an .sdf to my project, added a table, added a Linq-to-Sql dmbl, and tried to add the table to the dbml. The result was an error: "The selected object(s) are an unsupported data provider" This happens in both VS 2008 Professional SP1 and 2010 RC Ultimate. I found someone talking about… >>> More
SQL Server 2005 Merge Replication to SQL Server CE 3.5

as seen on Server Fault - Search for 'Server Fault'
Hi, In my organization, we have a SQL Server 2005 database server (DBServer). Users of an application will normally be connected to DBServer, but, occasionally, would like to disconnect and continue their work on a laptop using SQL Server Compact Edition 3.5 (SQLCE). Due to this, we have been looking… >>> More