Get RecCount without a count(...)?

vortex · Post by **vortex** » Wed 28 Jun 2006 12:42

Hi!

I was wondering if there was some smart way to retrieve record count without actually running a count (which getreccount seems to do)?

Our problem is that the query answers might:
* be quite large (possibly millions of rows)
* take a loong time (as in hours in some odd cases)
which means we do not want to run the same query twice (as in a separate count) or fetch all rows (at least not default).

Is this possible?

Challenger · Post by **Challenger** » Thu 29 Jun 2006 10:58

As far as we know there are no other ways to determine record count.