Hi There

I have a question for all you Database gurus out there.



I wish to write out a standard HTML page using the contents of a 2way 

array.



I have created the code do this and have placed it all on one ASP page 

next I want to be able to page through the array as if I were using a 

pageable recordset.



So on the first call to the page I load the array and display records 1-10 

on subsequent calls to the SAME page do I have to requery the database and 

rebuild the array or can I maintain the array in memory without having to 

hit the database again ????



Any thoughts 



Martin 

Two options:



a) You could reduce the size of the array that you are getting. .getRows()

allows you to specify how many records your wish to get. This is the fastest

method of paging that I've found:

http://www.adopenstatic.com/experiments/recordsetpaging.asp



b) If you want to keep the results in memory, unless the contents of the

array are going to be the same for each and every visitory, you're going to

really chew up your server's memory holding results sets for each user.

Howeever, if the results are static for each user you could use the rsFast

library developed by Charles Carroll here:

http://www.learnasp.com/learn/rsfast.asp



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

----- Original Message -----

From: <martin@s...>

To: "ASP Web HowTo" <asp_web_howto@p...>

Sent: Monday, June 18, 2001 9:10 AM

Subject: [asp_web_howto] Using getrows





: Hi There

: I have a question for all you Database gurus out there.

:

: I wish to write out a standard HTML page using the contents of a 2way

: array.

:

: I have created the code do this and have placed it all on one ASP page

: next I want to be able to page through the array as if I were using a

: pageable recordset.

:

: So on the first call to the page I load the array and display records 1-10

: on subsequent calls to the SAME page do I have to requery the database and

: rebuild the array or can I maintain the array in memory without having to

: hit the database again ????

:

: Any thoughts