Get RecCount without a count(...)?
Posted: 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?
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?