Fast Record Counts....

Results 1 to 2 of 2

Thread: Fast Record Counts....

  1. #1
    Join Date
    Dec 1969

    Default Fast Record Counts....

    I am currently displaying a list of records in a table alphabetically. The total number of records could soon be in the range of 100,000 - 200,000.<BR><BR>I know that counting records using a &#039while not recordset.eof, no_recs=n0_recs+1 recordset.movenext&#039 type of construct is not quick at all so I am doing SQL &#039Select count from ....&#039 statements.<BR><BR>Would this be the right approach??? <BR>any tips on speedy record counts etc..<BR>thanks.......<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Fast Record Counts....

    Why not just use the .recordcount method of the recordset object. i.e. rst.RecordCount. The only draw back here is you need to use a static cursor, and if you keep getting -1 for this, there is a good article on 4guys that explains it.<BR><BR>HTH<BR><BR>Jerry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts