中央数据库问题 [英] Central Database Problem

问题描述

大家好吧:)



我有一个商店管理系统，这个公司有4个分支机构，每个分支机构有4个系统客户端。



4个分支机构通过互联网连接在中央数据库上工作，这里的问题是数据保存和检索速度更慢。



所以有这个问题的解决方案或还有另一个模块要实施？



提前谢谢

Hi everyone :)

I have a Store Management System for a company that have 4 branches and each branch have 4 system clients.

The 4 branches works on a central database over internet connection, the problem here is the data saving and retrieving are more slow.

So there is any solution for this problem or there is another module to be implemented ?

Thanks in advance

推荐答案

有各种各样的选择，这是一个非常广泛的方法对于事物。

这也取决于你想要如何操作。



如果网站不需要100％最新信息那么你可以使用数据同步方法：

选择数据同步技术 [ ^ ]



如果他们确实需要最新信息，那么您可以在检索大量数据时使用分页方法，或者优化数据在它们之间的传输方式。提交信息时，可以利用回调方法中的线程和处理故障。这意味着您可以提交大量数据，并在提交时继续使用该程序的其他方面（如果该套件适合您的操作）。



您还可以查看可以应用的压缩。



如果不了解您的系统，很难提供建议，但这些是可以考虑的方法。

There are various options to you, and this is a very broad approach to things.
It also depends how you want to operate.

If the sites do not need 100% up to date information then you could use Data Synchronisation approaches:
Choose a Data Synchronization Technology[^]

If they do need upto date information then you could work on a paging method when retrieving large amounts of data, or refine how your data is transmitted between them. When submitting information take advantage of threading and handling failures on a call back method. This means you can submit large amounts of data and keep using other aspects of the program while it submits if that suites your operation.

You could also look into compression which could be applied.

Without knowing much more about your system it is hard to advice but those are some approaches that could be considered.

这篇关于中央数据库问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！