同步Frmework [英] Synch Frmework

问题描述

客户端计算机上的批处理目录是否有可能被删除？

我们实现了单向同步（下载），我们完全一样编写的代码在MSDN中提供。

我们的服务器数据库包含25-30个表。如果这些表更新为1000条记录，则每条记录将需要与客户端数据库同步的大量数据。同步框架中是否有任何限制，且数据量可以与
同步？

我们已启用批处理，但同步框架需要花费大量时间完成同步过程，大部分时间都失败。

请告诉我限制是否存在以及是否有任何我们需要遵循的加速机制。

我们已安排Synch每晚运行。

解决方案

批处理实际上并没有帮助加快速度，而是它解决了不可靠的网络和低内存问题。它实际上会降低同步速度，因为必须将更改保留到文件中，并且在应用之前从这些文件重建数据集。

您可能想要像其他任何一样将Sync Fx视为数据库应用程序，它在数据库设计，索引等方面进行相同的优化...

签出调整和监控性能在文档中为一般的准则。

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.

解决方案

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.

这篇关于同步Frmework的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！