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: For an index on string type columns, SQLCE uses LCMapString API to get the normalized sort key. LCMapString API behavior will be different for different NLS sort versions….

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 columns Transfer encryption of data payload on web Batching the changes                  Filtering the data at various…

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 for SQL Server Compact, along with pointers…