Performance of the sql compact sync-provider is horrible. It should be easy for you to improve it greatly. When will the next version be available?
Donnerstag, 7. Mai 2009 11:58
We are developing an application where we are using sync services for ado.net (desktop). As the ship-date comes closer, we are running into some serious performance-issues.
We are using it in download-only-mode, so the insert-performance (in ApplyChanges of SqlCeClientSyncProvider) is the main problem.
SqlCE is a lightning fast local database when it's utilized properly, but SqlCeClientSyncProvider it making it seem snail slow.
Inserting a few hundred rows takes several seconds, with proper use of connections and SqlCeResultSet it should take milliseconds.
And you are certainly aware of these issues:
January 12, 2009, Sean Kelley wrote in this thread: http://social.msdn.microsoft.com/forums/en-US/uklaunch2007ado.net/thread/2988bdef-b946-4d2a-a5e2-fe87bdebf6b8/
The SQL Compact team has also put together a prototype of a version of the Compact provider that leverages SqlCEResultSet which improves insert performance drastically. I meet with them next week to determine the appropriate ship vehicle for these changes. Again, I do not have hard dates yet but know that we recognize that this is a huge gap in our current product offering and will make efforts to address this gap.
And Wednesday, January 14, 2009 in this thread: http://social.msdn.microsoft.com/forums/en-US/uklaunch2007ado.net/thread/ec51bc07-f5fe-4218-ba77-bbb34cde4489/
We are also aware of the improvements that can be realized through a more intelligent use of CE connection objects. These improvements are a no brainer and will be our first line of attack.
That is 4 months since now, so my question is: will there be a new version soon? Or a CTP? Or simply a service pack, fixing the “no brainer”-connection issue, that would help a lot.
Sync services is working great for us otherwise, but the performance is killing us.
- Verschoben Hengzhe Li Freitag, 22. April 2011 03:18 (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
Donnerstag, 7. Mai 2009 18:16There is information about the next version here: http://blogs.msdn.com/sync/archive/2009/05/02/new-webcast-video-drill-down-into-the-next-release-of-the-microsoft-sync-framework.aspx - I would not expect to see anything before VS 2010 is available, but who knows.
Erik Ejlskov Jensen, MCTS: WM App, MCITP: SQL 2008 Dev - http://erikej.blogspot.com Please mark as answer, if this was it.
Donnerstag, 7. Mai 2009 18:56We had the same problem. For big amount of data, the sync framework is really slow...A solution is bulk data copy, You can call it through SMO.