locked
Synch Frmework RRS feed

  • Question

  • Is there any chances when the batch directory on client machine does not get deleted?.

    We have implemented one way Synch(download) and we have exactly the same code written that is provided in MSDN.

    Our server database contain 25-30 tables. If these tables are updted with 1000 records each their will be a large amount of data that needs to synch with the Client DB. Is there any limitation in the Synch Framework with the amount of data that can be synched ?.

    We have enabled batching but the Synch Framework takes a lot of time to complete the synch process and most of the time it fails.

    Kindly tell me the limitations if any and also to is there any speed up mechanism that we need to follow.

    We have scheduled the Synch to run every night.

    Friday, November 12, 2010 6:46 AM

All replies

  • batching doesnt actually help speed things up, rather its to address unreliable networks and low memory issues. it actually slows down sync since the changes has to be persisted to files, and the dataset rebuilt from these files before being applied.

    you might want to think of Sync Fx as just like any other database applications, its subject to the same optimisation on database design, indexing, etc...

    check out Tuning and Monitoring Performance in the documentation for some general guidelines.

    Friday, November 19, 2010 1:07 AM
  • Thanks for your valuable inputs

    I have problem with the batch files.

    The batch files are sometimes not getting cleaned up on the server and its taking huge memory. What may be the reason?

    What steps needs to be taken to delete the file if its not deleted by Synch?

    Wednesday, November 24, 2010 12:55 PM