Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

ASP Cache Page

Posted on 2004-10-31
14
Medium Priority
?
203 Views
Last Modified: 2011-10-03
hi,

Is this doable???   I have SQL DB... thx
0
Comment
Question by:mcrmg
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 5
14 Comments
 
LVL 46

Assisted Solution

by:fritz_the_blank
fritz_the_blank earned 1080 total points
ID: 12457195
0
 

Author Comment

by:mcrmg
ID: 12457564
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
 
LVL 46

Expert Comment

by:fritz_the_blank
ID: 12457591
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

by:mcrmg
ID: 12457624
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
 
LVL 46

Expert Comment

by:fritz_the_blank
ID: 12457777
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
 

Author Comment

by:mcrmg
ID: 12457822
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
 

Expert Comment

by:dileedil
ID: 12457848
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
 
LVL 46

Expert Comment

by:fritz_the_blank
ID: 12458097
I believe that he is trying to cache the page, not avoid caching it.

FtB
0
 

Author Comment

by:mcrmg
ID: 12458142
yeah........or if there better way....such as using static table or xml
0
 
LVL 46

Expert Comment

by:fritz_the_blank
ID: 12458197
This will only save resources for complicated SPs. For simpler ones, there is no real performance gain.

FtB
0
 

Author Comment

by:mcrmg
ID: 12458223
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
 
LVL 46

Expert Comment

by:fritz_the_blank
ID: 12458241
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
 
LVL 46

Assisted Solution

by:fritz_the_blank
fritz_the_blank earned 1080 total points
ID: 12458248
0
 
LVL 46

Accepted Solution

by:
fritz_the_blank earned 1080 total points
ID: 12458251
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question