Re: Device to Desktop DB sync options sans IIS

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

For the download only scenarios you can improve the time it takes to load the data by using SqlCeResultSet instead of DataSet. There's a sample somewhere on the Sync Services Forum. RDA achieves the load performance it gets by something like a bulk load. You still won't get that performance with SqlCeResultSet, but it will be much better.

Sync Services for Devices also has an impediment since it uses the XmlSerializer (the only serializer supported natively by the Compact Framework), which is bulky, slow and a memory hog compared to a binary serializer. (There are 3rd party binary serializers available for the Compact Framework, but none that are part of the Compact Framework.) The Sync team is looking at a number of ways to improve sync performance in the next version, or you could try using your own binary serializer. Until that time, another approach would be to initially populate the database on the desktop and just send that whole file to the device, but I don't know if that would be practical for your scenario.

--

Ginny Caughey
Device Application Development MVP



"fuzz_ball" <chris.r.putman@xxxxxxxxx> wrote in message news:9292cfae-62ae-4b1d-a1ea-9062b39538b9@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Wow, well I can't say I'm too excited with this ADO.NET for Devices. I
dearly hope I'm doing something wrong, because it took over 22 minutes
to sync a 5.3 MB DB. When using RDA previously, it was just a few
minutes. Does anyone have any performance tips?

.

Relevant Pages

  • Re: EXT4-ish "fixes" in UBIFS
    ... Under normal load, mounting without sync is fine. ... to do is mount with "remount,rw,sync" when heavy load is starting. ... done, I remount without sync ...
    (Linux-Kernel)
  • Re: EXT4-ish "fixes" in UBIFS
    ...  Under normal load, mounting without sync is fine. ... done, I remount without sync ...
    (Linux-Kernel)
  • Re: EXT4-ish "fixes" in UBIFS
    ...  Under normal load, mounting without sync is fine. ... will greatly reduce latency of fsync under heavy write load. ...
    (Linux-Kernel)
  • Re: EXT4-ish "fixes" in UBIFS
    ...  Under normal load, ... to do is mount with "remount,rw,sync" when heavy load is starting. ... certainly aware that mounting with "-o sync" has severe performance ...
    (Linux-Kernel)