select count vs Dcount

  • Thread starter Thread starter Souris
  • Start date Start date
S

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,
 
Souris said:
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,
Click to expand...

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.
 
Back
Top