fasterr than RecordCount?

Hi,

I often need the number of records in a recodset.I use RecordCount, but is
there no faster way, because sometimes, it takes a while.

Thanks
Mich

Re: fasterr than RecordCount?

Mich wrote:
> Hi,
>
> I often need the number of records in a recodset.I use RecordCount,
> but is there no faster way, because sometimes, it takes a while.
>
> Thanks
> Mich

Ways to get record count:
http://www.aspfaq.com/show.asp?id=2193

Options for handling recordsets - speed comparisons:
http://www.aspfaq.com/show.asp?id=2467

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Re: fasterr than RecordCount?

Thanks for answering

"Bob Barrows [MVP]" schreef in bericht
news:ev1hD3mvEHA.3908@TK2MSFTNGP12.phx.gbl...
> Mich wrote:
> > Hi,
> >
> > I often need the number of records in a recodset.I use RecordCount,
> > but is there no faster way, because sometimes, it takes a while.
> >
> > Thanks
> > Mich
>
> Ways to get record count:
> http://www.aspfaq.com/show.asp?id=2193
>
> Options for handling recordsets - speed comparisons:
> http://www.aspfaq.com/show.asp?id=2467
>
> Bob Barrows
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>

Re: fasterr than RecordCount?

I'd imagine it's your query that takes a while, not the method you use to
derive the count.

--
http://www.aspfaq.com/
(Reverse address to reply.)




"Mich" wrote in message
news:Os5psnmvEHA.3320@TK2MSFTNGP14.phx.gbl...
> Hi,
>
> I often need the number of records in a recodset.I use RecordCount, but is
> there no faster way, because sometimes, it takes a while.
>
> Thanks
> Mich
>
>