469,903 Members | 2,018 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,903 developers. It's quick & easy.

caching asp pages

What would be the norm for caching asp pages with an ec-commerce site.
What im after is should i set the cach directives to different types for the
different types of pages in an asp /sql application.
Ie, Dynamic Reports, data entry pages, static menu pages. etc.
Does anyone have any thoughts or guidlines in this ?.
Regards Don
Jul 19 '05 #1
1 1296
With ASP.NET, this is much easier. With ASP, you have to write the engine.
The best solution is to create a COM engine that stores the cache and use
GetObject() each time to grab the instance. This is quite time consuming to
program.

Another option is an ISAPI filter on the server to handle cache, but this
requires C++ programming. In most cases, this makes this option a
non-option.

You can store cache in either Application or Session, but you will lose the
ability to web farm, which affects scalability. If the goal is to reduce
cycles burned on common reports, you can do one of two things:

1. First time the report is run, cache a copy of the resulting HTML in a
file. File access here is quicker than crunching the DBMS each time (most
likely SQL Server?)

2. Run common report(s) at night. This can be via an application, or, in SQL
Server, by using the built in HTML capabilities to save the daily report(s).
This is rather efficient for daily reports.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************** ********************
Think Outside the Box!
************************************************** ********************
"Don Grover" <sp******@assoft.com.au> wrote in message
news:uT**************@TK2MSFTNGP12.phx.gbl...
What would be the norm for caching asp pages with an ec-commerce site.
What im after is should i set the cach directives to different types for the different types of pages in an asp /sql application.
Ie, Dynamic Reports, data entry pages, static menu pages. etc.
Does anyone have any thoughts or guidlines in this ?.
Regards Don

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Captain Chaos | last post: by
reply views Thread by Troy Simpson | last post: by
3 posts views Thread by Janaka | last post: by
8 posts views Thread by Nick Gilbert | last post: by
3 posts views Thread by moondaddy | last post: by
13 posts views Thread by Rohit | last post: by
13 posts views Thread by tshad | last post: by
reply views Thread by Raj | last post: by
3 posts views Thread by Purti Malhotra | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.