Dlookup跑得很慢 [英] Dlookup running very slowly

问题描述

我的一些Dlookup运行速度非常快，有些需要3到4秒才能返回一个值。慢速来自的表只有10条记录和3列。


Dlookup运行缓慢的原因是什么？

Some of my Dlookups run very fast, where some take up to 3 or 4 seconds to return a value. The table the slow one is coming from is only 10 records and 3 columns.

What are the causes for Dlookup to run slow?

推荐答案

通常，像任何表访问一样，通过非索引字段进行搜索将是我最好的猜测。

Generally, like any table access, searching via a non-indexed field would be my best guess.

将它们更改为索引但速度相同

Changed them to indexed but still the same speed

没有其他想到的了。


你怎么知道它实际上是 DLookup（）电话'实际上吃了时间？你在追踪它吗？可能是形式初始化还是其他可能混淆水域的因素？

Nothing else comes to mind.

How do you know it is actually the DLookup() call that''s actually eating up the time? Are you tracing it? Could it be form initialisation or other such factors muddying the waters perhaps?

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