ASP Cache Page

hi,

Is this doable???   I have SQL DB... thx
mcrmgAsked:
Who is Participating?
 
mcrmgAuthor Commented:
I looked at http://www.4guysfromrolla.com/webtech/091099-1.shtml( sine I am using ASP)

It says that it will use server memory to hold the content...........will it use up RAM??? thx
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
fritz_the_blankCommented:
That is what it would do.

I havenb't worked much with caching directing my attention instead to writing leaner code and storing persisted information in xml files rather than sending multiple trips to the db and etc.

What is it that you are trying to accomplish exactly?

FtB
0
 
mcrmgAuthor Commented:
okay, let's set .net aside for a min.

When I just took over this project.  We used ASP and Access, but it was not working.  Once it worked, my boss wanted me to move it over to SQL which is nearly done.
(As you can see in my question list, I asked a lot of Access questions, then mostly, I am asking about SQL now)

But since I have been working on DB side, I did not touch ASP side.  I am thinking next step, I want to use .net, even without .net, I want to make it run faster instead of call sp everytime..............

I do not know which way is the best...thx
0
 
fritz_the_blankCommented:
First, moving to the SP will speed things up considerably. Now, if the data does not change often, and the SP is complex, then you may see some advantage to running the SP only periodically and then saving the results to a temporary table, to xml, or to some other static source.

FtB
0
 
mcrmgAuthor Commented:
Results do not get changed very often, if I move the results into a static table, then it means the table will keep growing.....but it will spped up the process.


if I use xml, then that means that I have do a lot of work....which is fine..........

in terms of log term consideration, which way would you prefer?  thx
0
 
dileedilCommented:
Use this code ,
That will help you to avoid cache problem

Response.Buffer = True
Response.Expires = 0
Response.Expiresabsolute = Now() -1
      Response.AddHeader "pragma","no-cache"
      Response.AddHeader "cache-control", "private" 'stops proxy server cache
      Response.CacheControl = "no-cache"
0
 
fritz_the_blankCommented:
I believe that he is trying to cache the page, not avoid caching it.

FtB
0
 
mcrmgAuthor Commented:
yeah........or if there better way....such as using static table or xml
0
 
fritz_the_blankCommented:
This will only save resources for complicated SPs. For simpler ones, there is no real performance gain.

FtB
0
 
mcrmgAuthor Commented:
Yes, that's what I want.  For most of the reports on ASP, they all use single sp, the performance is fine.

So, do you think that using staic table is fine or use xml?  thx
0
 
fritz_the_blankCommented:
You may need to ask this in the sql server section, but there is a way to export table to a static xml file directly from sql server without having to use ASP. You can even put a trigger together so that the xml file is updated when the data changes. Then you can just use the xml file as the source for your asp pages.

FtB
0
All Courses

From novice to tech pro — start learning today.