Is there a way to cache a query on the server's memory for a certian amount of time?
-
-
Re: caching a query
Use ASP.net. Please provide more details, like, maybe indicating what
database system you're using, for one.
Ray at work
"joethis" <anonymous@disc ussions.microso ft.com> wrote in message
news:293BD218-DEDE-49CA-A6C7-A218E79C6D7D@mi crosoft.com...[color=blue]
> Is there a way to cache a query on the server's memory for a certian[/color]
amount of time?
-
Re: caching a query
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?
Comment
-
Re: caching a query
joethis wrote:[color=blue]
> 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?[/color]
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).
Comment
Comment