caching asp pages

[Don Grover]

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

 

[Cowboy \(Gregory A. Beamer\)]

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!
**********************************************************************