select count vs Dcount

[Souris]

I just learn that Dcount is slower than select count(*) from my table.

Does it mean that we need to use SQL every where in the applications?
Are there any rules to when to use which one?


Your information is great appreciated,

 

[Rick Brandt]

I just learn that Dcount is slower than select count(*) from my table.

Does it mean that we need to use SQL every where in the applications?
Are there any rules to when to use which one?


Your information is great appreciated,

Where did you learn it? In most cases it is not slower or the difference is
negligable.

The domain functions DSum(), DCount(), etc, are not good to use in Queries
or looping operations where they are executed numerous times over and over.
In other situations they are just as fast as other methods.