Hello
To put my question in short:
Will I have a performance loss if I only define SelectIncrementalUpdates and not SelectIncrementalInserts in a senario where the vast majority of the synchronized data rows will actually be inserts?
Background:
When I started to read on sync framework I came across an article (i think it was on sync guru) that gave the hint that if you have a SyncAdapter with syncdirection download only you don't have to specify any other select command than selecetIncrementalUpdates. Due to the cumbersome filtering control I've decided to only implement this.
During the course of our project the synchronization have become quite time consuming, and the majority of the time is spent on the devices, after the xml is parsed to the DataSet.
It recently hit me that only define selectincrementalupdates might be one cause for this. I.e. if the device receives a lot of data rows as updates when they don't exist in the target database it have to do two database commands for each rows. This is only a guess from my side - I haven't seen any detailed information about how SqlCeClientSyncProvider works internally.
