Hello

What should be faster for getting the total record number?

The RecordCount  function or runing a Query (select count ...)

Thanks Sorin

Hershcu


It will depend on just what you have to do to get there eg is the table already linked to a component and open, does the query have to be created etc.

Given an already open table my bet would go to RecordCount but unless you're doing it thousands of times in a loop I doubt you'd every detect the difference.

Final point - why not just try it and see?

Roy Lambert [Team Elevate]

Hershcu,

<< What should be faster for getting the total record number?

The RecordCount  function or runing a Query (select count ...) >>

Both are equivalent as long as your query takes the form of:

SELECT COUNT(*) FROM MyTable
[WHERE ... (optional)]

--
Tim Young
Elevate Software
www.elevatesoft.com