Session Arrays??

[Mighty]

Guys,

I have a page that gets called by itself several times and displays information that it reads from a database. However, at the moment it is extremely inefficient as each time the page is accessed it reads the data from the database. Is there any way that I can store the data the first time the page is accessed i.e. reading the data from the database into a recordset and somehow storing this recordset in a session level array or something like that? Mise Le Meas,

Mighty

 

[link9]

You can store your recordsets in session arrays, and then read them each time the page is reloaded.

The syntax for objects (such as recordsets) is:

set session("myRS&quot = myRS

syntax for regular variables (and arrays) is:

session("myVar&quot = myVar

It's not a recommended practice to store recordsets in session variables if there is a large amount of traffic on your site. It will seriously affect the performance of your site if there are.

However, if there aren't many users on the site, then it's a really quick and easy way to make data persistent.

good luck!
Paul Prewett

 

[Mighty]

link9,

Once the recordset is stored in the session variable as above, how do I access it? Do I use array notation or recorset notation. e.g. is it session("myRS&quot.MoveFirst or is it session("myRS&quot(0) Mise Le Meas,

Mighty

 

[RobV]

First copy the session variable to a local variable and then use it:

set myRs = session("myRs")
myRs.MoveFirst

Yours,

Rob.