records on multiple page

Results 1 to 2 of 2

Thread: records on multiple page

  1. #1
    Join Date
    Dec 1969

    Default records on multiple page

    Hello <BR><BR>Is there a way to display a large array of 1000 to 2000 records on several pages?<BR><BR>I know you can use objRS.pagesize, objRS.absolutepage, and objRS.pagecount if you want to display large recordset on multiple page. Isn&#039;t objRS just a large array<BR><BR>How you do same for large array? <BR><BR>Appreciate your help

  2. #2
    Join Date
    Dec 1969

    Default Probably bad idea...

    Sure, this is *trivial* to do.<BR><BR>You store the array in a session variable and just display "chunks" from the array in various pages.<BR><BR>But let&#039;s say you have 2000 records in the array. At roughly 8000 bytes each (just to pick a number). That&#039;s 16 MEGABYTES of space *PER ACTIVE USER* that you need for the session variables! Even if you&#039;ve got 1GB of memory on your machine, and ignoring the space needed by the OS and ASP and IIS and whatever else is running, you could only have about 60 active sessions!<BR><BR>

Posting Permissions

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