«

Is there a way to cache a query on the server's memory for a certian amount of time?

Use ASP.net. Please provide more details, like, maybe indicating what
database system you're using, for one.

Ray at work

"joethis" <> wrote in message
news:293BD218-DEDE-49CA-A6C7-...
> Is there a way to cache a query on the server's memory for a certian
amount of time?

In Coldfusion you can cache the resultset itself in memory. I was wondering if it was possible to cache the result set for a certain amount of time?

joethis wrote:
> In Coldfusion you can cache the resultset itself in memory. I was wondering if it was possible to cache the result set for a certain amount of time?

Save the resultset to Application or Session variable(s) using either
the recordset GetRows() or GetString() method or save it to a disk file
with the recordset Save() method.

But first be certain that you need to cache the result set (e.g., maybe
you don't need to fetch it all at once).