Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Performance   (RSS)

After moving the database from one platform to other, the first SqlCeConnection.Open() takes more time

If you move a SQLCE database from one platform to other, it's first SqlCeConnection.Open() takes more time and also increases the database file size. The Reason : F or an index on string type columns, SQLCE uses LCMapString API to get the normalized sort

Sync Services optimizations

There are some optimizations that can be done for an "Sync Services" sync scenario. These are, (might not be an exhaustive list) Small sync chunks (using smaller SyncGroups which are only absolutely necessary) Index creation on tracking and filtering
Posted by SQLCEBLOG | 0 Comments

Query performance

Understanding the reason for slowness of a SQL query and then tuning to boost it is a slightly complicated process, but it can be extremely rewarding in some cases. In this post, I am going to list down some ways in which you can tune the query performance
 
Page view tracker