What is the underlying code in DLOOKUP?

[Whizbang]

The Domain Aggregate functions are very slow, everyone knows this and has fought with it. ELookup is a good, fast solution (though with a couple limitations). But why is DLookup so slow? What is it doing that can sometimes take 2 or 3 seconds for a single calculation? Why is there such a variance in calculation time between DLookup and ELookup, when they both do the same thing? Has anyone ever cracked the DLookup function and taken a look at the code underneath to determine why it is the way it is? What does it do that ELookup does not do? Obviously it somehow handles parameter queries better, but would that really cause it to slow down so much? I can kind of see that it would have to convert parameter queries into sub-queries, but even then I don't see it adding a lot of processing time.



Wierd. Anyone have any resources or insights for me?

[June7]

I don't know why DLookup can be slow in queries. It is adequate for my needs in VBA.

For those who don't know, ELookup is a custom function. Review http://allenbrowne.com/ser-42.html