Slow and RecordCount

Results 1 to 2 of 2

Thread: Slow and RecordCount

  1. #1
    Join Date
    Dec 1969

    Default Slow and RecordCount

    I'm reading a fairly large table (25000 records) to get a count and display it on the home page. It's taking 5-8 seconds, which is too long for a home page. I'm using RECORDSET.RECORDCOUNT (,3,3,1) but still takes a long time. The question is: Is there a way to speed this up? May be ASP.NET? How about running after the home page is displayed, and then run the process and pluging in the results? HELP! Thanks.

  2. #2
    Join Date
    Dec 1969

    Default RE: Slow and RecordCount

    use..<BR>select count(*) from tablename. <BR><BR>Right now, you&#039;re reading every record into the the recordset...not necessary if you&#039;re just looking for the count

Posting Permissions

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