CODEWITHSUNDEEP
c#sql-server-2008sql-server-cemicrosoft-sync-framework
Simsons
Simsons

Reputation: 12745

What are the factors need to be taken into consideration while using Microsoft Sync Framework

Right now we have got an developed application for maintenance and one of the major issue is the Sync Time.

It's almost taking 50 to 60 secs to synchronize between the local CE database and remote SQL Server.

It takes less than 12secs while synchronizing the same local CE database with local SQL Server.

This points that location of server is definitely ruling the grounds but again what are the other factors need to be evaluated while using Microsoft Sync Framework.

Is there any standards specified as such how many scopes and how to use provisioning efficently.

Upvotes: 0

Views: 112

Answers (1)

JuneT
JuneT

Reputation: 7860

Too long to post here, so posting a link instead : Sync Framework Scope and SQL Azure Data Sync Dataset Considerations

Other things you can look at are batching and metadata clean up.

Note that Sync Framework is just like any other database app, so stuff like proper indexing also is a plus.

Upvotes: 1

Related Questions