Size really matters...

Results 1 to 3 of 3

Thread: Size really matters...

  1. #1
    Join Date
    Dec 1969

    Default Size really matters...

    Hi,<BR>I&#039;m back with more questions concerning the problems with tooo big recordset to be displayed...When I try to display all the records from rs for particular date (e.g. LoggedAt between &#039;07/31/2003 00:00:00&#039; and &#039;07/31/2003 23:59:59&#039;) I get:<BR>&#039;The page you are looking for is currently unavailable. The Web site might be experiencing technical difficulties, or you may need to adjust your browser settings.&#039; <BR>But when I change the time part of SQL to be between 00:00:00 to 15:00:00 for example, it works fine.<BR>SO I guess , the size of rs really matters (for IIS or IE).<BR>rs with my SQL statement contained approx 13000 records - is it too big to be displayed?<BR>Mr.M

  2. #2
    Join Date
    Dec 1969

    Default RE: Size really matters...

    13,000 records? yes, too big.<BR><BR>the significant thing for me is that this many records are just beyond usable by a human being, so why do you want to display them??<BR><BR><BR>j<BR>

  3. #3
    Join Date
    Dec 1969

    Default I agree with Atrax...

    ...and strongly suggest you split them up into smaller chunks. There are various FAQs etc. on this site (if I&#039;m not mistaken) which show you how to page through a large recordset.<BR><BR>Oliver.

Posting Permissions

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