Solved

ASP Cache Page

Posted on 2004-10-31
189 Views
Last Modified: 2011-10-03
hi,

Is this doable???   I have SQL DB... thx
0
Question by:mcrmg
    14 Comments
     
    LVL 46

    Assisted Solution

    by:fritz_the_blank
    0
     

    Author Comment

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

    Author Comment

    by:mcrmg
    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
    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
    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
    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
    I believe that he is trying to cache the page, not avoid caching it.

    FtB
    0
     

    Author Comment

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

    Expert Comment

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

    FtB
    0
     

    Author Comment

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

    Accepted Solution

    by:
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Course: MongoDB Object-Document Mapper for NodeJS

    NodeJS (JavaScript on the server) is awesome, but some developers get confused about NoSQL when it comes to working in Node with MongoDB (NoSQL database). Do you need a better explanation of how to use Node.js with MongoDB? The most popular choice is the Mongoose library.

    Suggested Solutions

    Title # Comments Views Activity
    Select TOP 5 COUNT(*) 13 43
    CSS Question.. 3 55
    EOF BOF error classic asp 8 21
    Dreamweaver server behavior gone 6 32
    Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
    This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
    This video Micro Tutorial is the first in a two-part series that shows how to create and use custom scanning profiles in Nuance's PaperPort 14.5 (http://www.experts-exchange.com/articles/17490/). But the ability to create custom scanning profiles al…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    913 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

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now