Thursday, March 11, 2010

2 new Sync Services hotfixes for SQL Compact

Sync Services for ADO.NET for Devices 1.0 has been updated for performance. The initial release of this used DataSet on the device for INSERTs and UPDATEs, which caused large memory consumption and slow performance on the device. The updates uses SqlCeResult set instead of DataSet, preventing double-buffering of data (causing excessive memory consumption), and improved INSERT and UPDATE performance. When you synchronize data to a SQL Server Compact 3.5 database by using Sync Services for ADO.NET for Devices, the synchronization may be slow http://support.microsoft.com/kb/973058

The following SQL Compact hotfix addresses an issue that is commonly encountered when syncing tables with foreign key constraints:
FIX: Error message when an application inserts a value into a foreign key column in SQL Server Compact 3.5: "No key matching the described characteristics could be found within the current range" http://support.microsoft.com/kb/974068

No comments: