查询主副本和副本之间的速度差异 [英] Query speed difference between master and replica
问题描述
我的Access数据库使用一系列查询来生成(复杂)报告。在主数据库上生成报告需要12分钟。在该主服务器的副本中生成相同的报告需要一分钟或更短时间。我已经在
两台不同的计算机上测试了这几次(云中一台)并且结果是一致的。
任何人都可以告诉我为什么会这样差异很大?
My Access database uses a cascade of queried to produce a (complicated) report. Generating the report on the master db takes 12 minutes. Generating the same report in a replica of that master takes a minute or less. I have tested this several times on
two different computers (one in the cloud) and the results are consistent.
Can anyone tell me why there is such a large difference?
推荐答案
返回的数据是否相同?副本是否返回相同数量的记录?主机是否有代码告诉它在编译数据之前检查所有副本?
Is the returned data the same? Are the replicas returning the same number of records? Does the master have code telling it to review all replicas before compiling the data?
我认为副本只需要将值与主机进行比较,而主机必须将数据与每个副本进行比较。
I think a replica only has to compare values to the master while the master has to compare data with each replica.
但我不确定。
这篇关于查询主副本和副本之间的速度差异的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!