Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > caching a query

Reply
Thread Tools

caching a query

 
 
joethis
Guest
Posts: n/a
 
      05-21-2004
Is there a way to cache a query on the server's memory for a certian amount of time?
 
Reply With Quote
 
 
 
 
Ray at
Guest
Posts: n/a
 
      05-21-2004
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?


 
Reply With Quote
 
 
 
 
joethis
Guest
Posts: n/a
 
      05-21-2004
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?
 
Reply With Quote
 
Michael D. Kersey
Guest
Posts: n/a
 
      05-21-2004
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).
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Disable page caching without disabling caching of jpegs andstylesheets etc JimLad ASP .Net 3 01-21-2010 10:13 AM
ACNS 5.9.x Negative Caching Query?? Howard L Cisco 0 09-08-2008 09:15 AM
ACNS 5.9.x Negative Caching Query?? Howard L Cisco 0 09-08-2008 09:15 AM
Fragment Caching inside page caching? Troy Simpson ASP .Net 0 01-19-2004 11:57 AM
trouble with caching or caching the trouble Hypo ASP .Net 6 08-01-2003 07:11 AM



Advertisments
 



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57