Caching RecordSet

[Serge Myrand]

Hi,

I need an input! I am working on an ASP web application that allow
customers to order products from the web site. The products pages show
only 20 products at a time, I would like to avoid to requery the table
every time the user to navigate between pages (I do not know big the
table could be). Is there a way to cache the recordset or a way to make
it available "public" from page to page?

thank you in advance
serge

[Serge Myrand]

Thank you very much
serge

"Aaron [SQL Server MVP]" wrote:

> You could use XML data islands, or store the pages in HTML. However, this
> won't help when someone runs a search...
>
> Or, you could use a more efficient paging mechanism.
> [url]http://www.aspfaq.com/2120[/url]
>
> --
> [url]http://www.aspfaq.com/[/url]
> (Reverse address to reply.)
>
> "Serge Myrand" <info@softdelirium.qc.ca> wrote in message
> news:40E16796.223716FF@softdelirium.qc.ca...

> > Hi,
> >
> > I need an input! I am working on an ASP web application that allow
> > customers to order products from the web site. The products pages show
> > only 20 products at a time, I would like to avoid to requery the table
> > every time the user to navigate between pages (I do not know big the
> > table could be). Is there a way to cache the recordset or a way to make
> > it available "public" from page to page?
> >
> > thank you in advance
> > serge
> >

[Aaron [SQL Server MVP]]

You could use XML data islands, or store the pages in HTML. However, this
won't help when someone runs a search...

Or, you could use a more efficient paging mechanism.
[url]http://www.aspfaq.com/2120[/url]

--
[url]http://www.aspfaq.com/[/url]
(Reverse address to reply.)




"Serge Myrand" <info@softdelirium.qc.ca> wrote in message
news:40E16796.223716FF@softdelirium.qc.ca...

> Hi,
>
> I need an input! I am working on an ASP web application that allow
> customers to order products from the web site. The products pages show
> only 20 products at a time, I would like to avoid to requery the table
> every time the user to navigate between pages (I do not know big the
> table could be). Is there a way to cache the recordset or a way to make
> it available "public" from page to page?
>
> thank you in advance
> serge
>