Professional Web Applications Themes

fasterr than RecordCount? - ASP Database

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...

  1. #1

    Default 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


    Mich Guest

  2. #2

    Default Re: fasterr than RecordCount?

    Mich wrote: 

    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"


    Bob Guest

  3. #3

    Default Re: fasterr than RecordCount?

    Thanks for answering

    "Bob Barrows [MVP]" <SPAMcom> schreef in bericht
    news:phx.gbl... 
    >
    > 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"
    >
    >[/ref]


    Fred Guest

  4. #4

    Default 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" <michnomail> wrote in message
    news:phx.gbl... 


    Aaron Guest

Similar Threads

  1. something like recordcount?
    By phil in forum ASP.NET Data Grid Control
    Replies: 3
    Last Post: May 9th, 09:05 AM
  2. Dynamic RecordCount
    By H3ath0r in forum Coldfusion - Advanced Techniques
    Replies: 2
    Last Post: June 13th, 08:43 PM
  3. RecordCount
    By Mark in forum ASP
    Replies: 5
    Last Post: October 31st, 04:49 AM
  4. Getting a recordcount
    By Andy Levy in forum PHP Development
    Replies: 3
    Last Post: October 29th, 08:55 AM
  5. recordcount -1
    By middletree in forum ASP
    Replies: 8
    Last Post: October 16th, 02:06 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139