Source Code for http://www.brettb.com/ASPDataCaching.asp
<html>
<head>
<title>Improving ASP Performance With Data Caching</title>
<link REL="stylesheet" HREF="BrettbDotCom.css" TYPE="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="description"
content="Describes how to use caching with ASP - useful for sites using low performance databases such as Access">
<meta name="keywords"
content="cache, caching, performance, issues, data, database, connectivity, Access">
</head>
<body>
<script language="JavaScript">
function SubmitHeaderSearchForm() {
document.FormSubmitHeaderSearch.submit();
}
</script>
<div align="center"><table border="0" cellpadding="0" cellspacing="0" width="800"
style="border: 1px solid rgb(0,0,0)">
<tr>
<td width="167"><a href="Default.asp" title="Brettb.Com (Back to Home Page)"><img src="Images/BrettbDotCom_Logo.jpg" width="167" height="72"
alt="Brettb.Com" border="0"></a></td>
<td width="633"><img src="HeaderImages/Fluroescent-Tubes.jpg" width="633" height="72" alt=""></td>
</tr>
</table><table border="0" cellpadding="0" width="802" bgcolor="#DD3333"
style="border-left: 1px solid rgb(0,0,0); border-right: 1px solid rgb(0,0,0); border-top: 1px none rgb(0,0,0); border-bottom: 1px solid rgb(0,0,0)">
<tr>
<td class="TDHeader" valign="middle" align="left"> <a href="Default.asp"
title="HOME">HOME</a> | <a href="web.asp" title="ABOUT ME">ABOUT ME</a> | <a
href="Biotechnology.asp" title="BIOTECHNOLOGY">BIOTECHNOLOGY</a> | <a
href="technicalwriting.asp" title="ARTICLES">ARTICLES</a> | <a
href="DeveloperTools.asp" title="DEVELOPER TOOLS">TOOLS</a> | <a href="Gallery.asp"
title="GALLERY">GALLERY</a> | <a href="contact.asp" title="CONTACT">CONTACT</a></td>
<form method="POST" action="SearchResults.asp" name="FormSubmitHeaderSearch"><td align="right" class="TDHeader" valign="middle">Search: <input type="text" name="query"
size="20" maxlength="100"> <a href="javascript:SubmitHeaderSearchForm();">Go</a></td></form>
</tr>
</table>
</center></div>
<div align="center"><center>
<table border="0" cellpadding="8" cellspacing="0" width="802"
style="border-left: 1px solid rgb(0,0,0); border-right: 1px solid rgb(0,0,0)">
<tr>
<td bgcolor="#E0E0E0" width="151" valign="top" align="left" class="TDLeftPanel" nowrap><strong><a href="DeveloperTools.asp" title="DEVELOPER TOOLS">DEVELOPER TOOLS</a><br>
</strong> <a href="ASPDocumentationTool.asp" title="ASP Documentation Tool">ASP Doc
Tool</a><br>
<a href="ASPNetDocumentationTool.asp" title="ASP.NET Documentation Tool">ASP.NET Doc
Tool</a><br>
<a href="http://www.winnershtriangle.com/w/Products.SQLDocumentationTool.asp" title="SQL Documentation Tool" target="_blank">SQL Doc
Tool</a><br>
<a href="IndexServerCompanion.asp" title="Index Server Companion">Index Server
Companion</a><br>
<a href="TheWebsiteUtility.asp" title="The Website Utility">The Website Utility</a><p><strong>TECHNICAL
ARTICLES <br>
</strong> <a href="ASPWatchArticles.asp" title="ASP Articles">ASP</a><br>
<a href="ASP.NETArticles.asp" title="ASP.NET Articles">ASP.NET</a><br>
<a href="JavaScriptArticles.asp" title="JavaScript Articles">JavaScript</a><br>
<a href="SQL_Help.asp" title="Transact SQL Articles">Transact SQL</a></p>
<p><strong>PHOTO GALLERIES</strong><br>
<a href="CanonEOS300D_Gallery1.asp" title="Canon EOS 300D Samples">Canon EOS 300D
Samples</a><br>
<a href="Red_Arrows_2004.asp" title="Red Arrows 2004">Red Arrows 2004</a><br>
<a href="Living_Coasts_Photos.asp" title="Living Coasts">Living Coasts</a><br>
<a href="backgrounds.asp" title="Web Page Backgrounds">Web Page Backgrounds</a><br>
<a href="gallery.asp" title="More Galleries...">More Galleries...</a></p>
<p><strong>NEW STUFF</strong><br>
<a href="TransactSQLColorCoder.asp" title="Transact SQL Color Coder">SQL Color Coder</a><br>
<a href="CanonEOS300D_Gallery3.asp" title="Canon EOS 300D Samples">Canon EOS 300D
Samples</a><br>
<a href="TheWebsiteUtility.asp" title="The Website Utility">The Website Utility</a><br>
<a href="Website_Search_Engine_Optimisation.asp" title="Useful Search Engine Optimization Techniques">Search Engine Optimisation</a><br>
<a href="BuildingAnASPSearchEngine.asp" title="Creating an ASP Search Engine for your Website">Build an ASP Search Engine</a><br>
<a href="MyTropicalFishtank.asp" title="My Tropical Freshwater Fishtank">My Tropical Fishtank</a><br>
<a href="Investments_ISAs.asp" title="Savings & Investments">Savings & Investments</a><br>
<a href="what's_new.asp" title="What's New?">Other New Stuff...</a></p>
<p><strong>POPULAR STUFF</strong><br>
<a href="VBScriptRegularExpressions.asp" title="VBScript Regular Expressions">Regular
Expressions</a><br>
<a href="ASPDocumentationTool.asp">ASP Documentation Tool</a><br>
<a href="SearchingIndexServerWithASP.asp" title="Index Server & ASP">Index
Server & ASP</a><br>
<a href="js_banner_ad_rotator.asp" title="JavaScript Banner Ad Rotator">JavaScript Ad Rotator</a></p>
<p><strong>LINKS</strong><br>
<a href="http://www.winnershtriangle.com/w/Default.asp" title="Business Website"
target="_blank">Business Website</a><br>
<a href="http://authors.aspalliance.com/brettb/" title="ASPAlliance Articles"
target="_blank">ASPAlliance Articles</a><br>
</p>
<p><img alt="Microsoft Certified Professional"
src="images/MCP_c_smaller.gif" width="151" height="38"></p>
<p align="center">
<script type="text/javascript"><!--
google_ad_client = "pub-7044749527879330";
google_alternate_color = "FFFFFF";
google_ad_width = 120;
google_ad_height = 90;
google_color_border = "000000";
google_color_bg = "DDDDDD";
google_color_link = "FF0000";
google_color_url = "DD3333";
google_color_text = "CCCCCC";
google_ad_format = "120x90_0ads_al_s";
google_ad_channel ="6714185213";
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</p>
<p align="center">
<SCRIPT type='text/javascript' language='JavaScript' src='http://xslt.alexa.com/site_stats/js/s/a?amzn_id=brettbcom&url=www.brettb.com'></SCRIPT>
</p>
</td>
<td width="551" valign="top" align="left">
<p><a href="Default.asp" title="Home">Home</a> > <a href="technicalwriting.asp"
title="Articles">Articles</a></p>
<h1>Improving ASP Performance With Data Caching</h1>
<p>One of the nicest features of ASP.NET is the ability to cache page content. This can be
used to substantially reduce load on a website's database - which is an obvious attraction
if the site uses Microsoft's Access to store data rather than SQL Server.</p>
<p>Unfortunately there is no built in caching system in classic ASP, but it is easy to
build one by using the <strong>Application object</strong> to store data. As such the
techniques described in this article can be used to bring useful performance enhancements
to legacy websites where upgrading the database or porting the code to ASP.NET is not a
viable option.</p>
<h3>An Example of ASP Data Caching</h3>
<p>In this example, an e-commerce website contains a list of popular products visible in a
box displayed on all of the pages within the site. Since the website only takes 2 - 3
orders a day, the list of popular products does not need to be constantly updated. There
are three application variables required in the Application_OnStart subroutine of the
global.asa file: </p>
<p><font color="#000080">Application("CachingDuration") = 120 <br>
Application("PopularProductsHTML") = "" <br>
Application("PopularProductsHTML.LastModified") = Now()</font></p>
<p>The <i>CachingDuration</i> application variable specifies the number of minutes that
the website's cached content should be stored for. The <i>PopularProductsHTML</i>
application variable stores the actual HTML for the popular products table. Finally, the <i>PopularProductsHTML.LastModified</i>
application variable stores the date and time the popular products HTML was last retrieved
from the database. The ASP code for retrieving the popular products from the database is
containing within the function GetPopularProductsHTML. There is a single argument - the
number of popular products to return: </p>
<span style="background-color: #FFFF66">
<p></span><font color="#000080"><small><% <br>
<a name="8"></a>Function GetPopularProductsHTML(NumberOfProducts) <br>
<a name="9"></a> <br>
<a name="10"></a> On Error Resume Next <br>
<a name="11"></a> Dim DataConnection <br>
<a name="12"></a> Dim RecordSet <br>
<a name="13"></a> Dim SQL <br>
<a name="14"></a> Dim ReturnString <br>
<a name="15"></a> Dim ProductName <br>
<a name="16"></a> Dim NumberOfProductsDisplayed <br>
<a name="17"></a> <br>
<a name="18"></a> 'Access Query for returning popular products <br>
<a name="19"></a> SQL = "sp_GetPopularProducts" <br>
<a name="20"></a> <br>
<a name="21"></a> Set DataConnection =
Server.CreateObject("ADODB.connection") <br>
<a name="22"></a> DataConnection.Open
Application("ConnectionString") <br>
<a name="23"></a> <br>
<a name="24"></a> Set RecordSet =
Server.CreateObject("ADODB.Recordset") <br>
<a name="25"></a> <br>
<a name="26"></a> RecordSet.Open SQL, DataConnection <br>
<a name="27"></a> <br>
<a name="28"></a> NumberOfProductsDisplayed = 0 <br>
<a name="29"></a> <br>
<a name="30"></a> Do While Not RecordSet.EOF <br>
<a name="31"></a> <br>
<a name="32"></a> If
NumberOfProductsDisplayed < NumberOfProducts Then <br>
<a name="33"></a> <br>
<a name="34"></a> ProductName
= Replace(RecordSet("ProductName"), Chr(34), "'") <br>
<a name="35"></a> ReturnString
= ReturnString & "<a href=ViewProduct.asp?Product="" &
RecordSet("ProductID") & """>" & ProductName
& "</a><br>" <br>
<a name="36"></a> <br>
<a name="37"></a> End
If <br>
<a name="38"></a> <br>
<a name="39"></a> NumberOfProductsDisplayed
= NumberOfProductsDisplayed + 1 <br>
<a name="40"></a> <br>
<a name="41"></a> RecordSet.MoveNext <br>
<a name="42"></a> <br>
<a name="43"></a> Loop <br>
<a name="44"></a> <br>
<a name="45"></a> RecordSet.Close <br>
<a name="46"></a> Set RecordSet = nothing <br>
<a name="47"></a> DataConnection.Close <br>
<a name="48"></a> Set DataConnection = nothing <br>
<a name="49"></a> <br>
<a name="50"></a> GetPopularProductsHTML = ReturnString <br>
<a name="51"></a> <br>
<a name="52"></a>End Function <br>
<a name="53"></a>%> </small></font></p>
<p>This function is called from the ASP VBScript shown below that builds the popular
products table. This code also checks that the cached HTML has not expired; if it has
expired then the data is retrieved from the database.</p>
<span style="background-color: #FFFF66">
<p></span><font color="#000080"><small><% <br>
<a name="56"></a>Dim PopularProductsBoxTitleText <br>
<a name="57"></a>Dim PopularProductsBoxContentsText <br>
<a name="58"></a>Dim NumberOfProducts <br>
<a name="59"></a> <br>
<a name="60"></a>PopularProductsBoxTitleText = "Popular Products" <br>
<a name="61"></a>NumberOfProducts = 25 <br>
<a name="62"></a> <br>
<a name="63"></a>'If cache is empty then retrieve data from the database <br>
<a name="64"></a>If Application("PopularProductsHTML") = "" Then <br>
<a name="65"></a> <br>
<a name="66"></a> PopularProductsBoxContentsText =
GetPopularProductsHTML(NumberOfProducts) <br>
<a name="67"></a> <br>
<a name="68"></a> Application.Lock() <br>
<a name="69"></a> Application("PopularProductsHTML") =
PopularProductsBoxContentsText <br>
<a name="70"></a> Application("PopularProductsHTML.LastModified")
= Now() <br>
<a name="71"></a> Application.UnLock() <br>
<a name="72"></a> <br>
<a name="73"></a>'Retrieve content directly from the cache instead of the database <br>
<a name="74"></a>Else <br>
<a name="75"></a> PopularProductsBoxContentsText =
Application("PopularProductsHTML") <br>
<a name="76"></a> <br>
<a name="77"></a> 'Is the cache out of date? If so retrieve the
content from the database and store in the cache <br>
<a name="78"></a> 'The VBScript DateDiff function can be used to
compare dates (n = comparisons of minutes) <br>
<a name="79"></a> If DateDiff("n",
Application("PopularProductsHTML.LastModified"), Now()) >
Application("CachingDuration") Then <br>
<a name="80"></a> Response.Write("<!--Cache
Updated-->") 'Useful debugging line - remove from production code <br>
<a name="81"></a> PopularProductsBoxContentsText
= GetPopularProductsHTML(NumberOfProducts) <br>
<a name="82"></a> <br>
<a name="83"></a> 'Store the content in the
Application variables. <br>
<a name="84"></a> Application.Lock() <br>
<a name="85"></a> Application("PopularProductsHTML")
= PopularProductsBoxContentsText <br>
<a name="86"></a> Application("PopularProductsHTML.LastModified")
= Now() <br>
<a name="87"></a> Application.UnLock() <br>
<a name="88"></a> <br>
<a name="89"></a> End If <br>
<a name="90"></a> <br>
<a name="91"></a>End If <br>
<a name="92"></a> <br>
<a name="93"></a>'Display the popular products box <br>
<a name="94"></a>If PopularProductsBoxContentsText <> "" Then <br>
<a name="95"></a>%> <br>
<a name="96"></a> <div class="BoxOutline"> <br>
<a name="97"></a> <div
class="BoxTitle"> <br>
<a name="98"></a> <span
class="PopularProductsBoxTitleText"><%=PopularProductsBoxTitleText%></span>
<br>
<a name="99"></a> </div> <br>
<a name="100"></a> <div
class="BoxContents"> <br>
<a name="101"></a> <span
class="PopularProductsBoxContentsText"> <br>
<a name="102"></a> <%=PopularProductsBoxContentsText%>
<br>
<a name="103"></a> </span>
<br>
<a name="104"></a> </div> <br>
<a name="105"></a> </div> <br>
<a name="106"></a><% <br>
<a name="107"></a>End If <br>
<a name="108"></a>%> </small></font></p>
<p>Don't forget that content stored in Application variables are shared by all users of
the site, so if updating Application variables the <i>Lock()</i> method should be called
to prevent more than one client from modifying the same Application variable
simultaneously. Remember to use the <i>Unlock()</i> method afterwards! </p>
<h3>When to use ASP Caching</h3>
<p>Caching is most useful for data that changes - but not too often. For example an
e-commerce store could display a list of popular products, or an information site could
display a list of press releases. If you have several regions of this information on the
same page then the performance increase from caching could be substantial.</p>
<p>Don't forget that it is also possible to build functionality into the admin part of the
site so that the cache would be flushed if new content is added to the database. That way
the website administrator would not have to wait until the cache timed out in order for
new content to appear on the website.</p>
<p>Remember that data stored in Application variables is visible by all the users of the
website, so if your site uses extensive personalisation features you may be better off
caching data in the <strong>Session object</strong>.</p>
<h3>Links</h3>
<ul>
<li><a href="http://www.brettb.com/redirector.asp?URL=downloads/ASPDataCaching_Sample.zip">Download
the sample source code</a> (4.86 K ZIP file).</li>
</ul>
<ul>
<li>The <a href="http://www.winnershtriangle.com/w/Products.ASPDocumentationTool.asp"
title="ASP Documentation Tool">ASP Documentation Tool</a> can automatically document your
ASP (VBScript and JScript) websites - why not give it a go?</li>
</ul>
<h2>Useful Development Tools</h2>
<div align="left">
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="100%" valign="top"><a
href="http://www.winnershtriangle.com/w/Products.ASPDocumentationTool.asp" target="_blank" title="ASP Documentation Tool™"><strong>ASP
Documentation Tool™</strong></a></td>
</tr>
<tr>
<td width="100%" valign="top">Automatically creates developer documentation for ASP 2.0
and 3.0 web applications written in VBScript and JScript. Documentation for Microsoft
Access, SQL Server 7/2000 databases and Visual Basic 6.0 components associated with the
web application can also be incorporated into the reports. Documentation is created in
HTML, HTML Help and plain text formats.</td>
</tr>
<tr>
<td width="100%" valign="top">
<a
href="http://www.winnershtriangle.com/w/SampleWeb_Documentation/SampleWeb.chm"><img
src="images/Icon_CHM.gif" width="16" height="16" alt="View Sample Output (HTML Help format)"
border="0" align="absmiddle"></a> <a
href="http://www.winnershtriangle.com/w/SampleWeb_Documentation/SampleWeb.chm" title="View Sample Output (HTML Help format)">View Sample
Output</a> (HTML Help format).<br>
<a
href="http://www.winnershtriangle.com/w/SampleWeb_Documentation/Default.htm"><img
src="images/Icon_HTML.gif" width="16" height="16" alt="View Sample Output (HTML Format)"
align="absmiddle" border="0"></a> <a
href="http://www.winnershtriangle.com/w/SampleWeb_Documentation/Default.htm"
target="_blank" title="View Sample Output (HTML Format)">View Sample Output</a> (HTML Format).<br>
<a
href="http://www.brettb.com/redirector.asp?URL=downloads/ASPDocumentationTool_Evaluation_Version.zip"><img
src="images/Icon_Download.gif" width="18" height="20" alt="Download Trial Version"
border="0" align="absmiddle"></a> <a
href="http://www.brettb.com/redirector.asp?URL=downloads/ASPDocumentationTool_Evaluation_Version.zip" title="Download Trial Version">Download
Trial Version</a> (5.2Mb ZIP file).</td>
</tr>
</table>
<br>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="100%" valign="top"><a
href="http://www.winnershtriangle.com/w/Products.ASPNETDocumentationTool.asp" target="_blank" title="ASP.NET Documentation Tool"><strong>ASP.NET Documentation Tool</strong></a></td>
</tr>
<tr>
<td width="100%" valign="top">Automatically creates developer documentation for ASP.NET web applications written in C# or VB.NET.
Documentation for SQL Server 7/2000 databases and C#/VB.NET components associated with the
web application can also be incorporated into the reports. Documentation is created in
HTML, HTML Help and plain text formats.</td>
</tr>
<tr>
<td width="100%" valign="top">
<a href="http://www.winnershtriangle.com/w/ASP.NETDocToolSamples/SampleWeb.NET/SampleWeb.NET.chm"><img
src="images/Icon_CHM.gif" width="16" height="16" alt="View Sample Output (HTML Help format)"
border="0" align="absmiddle"></a> <a
href="http://www.winnershtriangle.com/w/ASP.NETDocToolSamples/SampleWeb.NET/SampleWeb.NET.chm" title="View Sample Output (HTML Help format)">View Sample
Output</a> (HTML Help format).<br>
<a
href="http://www.winnershtriangle.com/w/ASP.NETDocToolSamples/SampleWeb.NET/Default.htm"><img
src="images/Icon_HTML.gif" width="16" height="16" alt="View Sample Output (HTML Format)"
align="absmiddle" border="0"></a> <a
href="http://www.winnershtriangle.com/w/ASP.NETDocToolSamples/SampleWeb.NET/Default.htm"
target="_blank" title="View Sample Output (HTML Format)">View Sample Output</a> (HTML Format).<br>
<a
href="http://www.brettb.com/redirector.asp?URL=downloads/ASP.NETDocumentationTool_1.0.zip"><img
src="images/Icon_Download.gif" width="18" height="20" alt="Download Trial Version"
border="0" align="absmiddle"></a> <a
href="http://www.brettb.com/redirector.asp?URL=downloads/ASP.NETDocumentationTool_1.0.zip" title="Download Trial Version">Download
Trial Version</a> (2.9Mb ZIP file).</td>
</tr>
</table>
<br>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="100%" valign="top"><a
href="http://www.winnershtriangle.com/w/Products.SQLDocumentationTool.asp" target="_blank" title="SQL Documentation Tool"><strong>SQL
Documentation Tool</strong></a></td>
</tr>
<tr>
<td width="100%" valign="top">The SQL Documentation Tool creates technical documentation for Microsoft SQL Server 7.0 and 2000 databases. Technical documentation is created in HTML and HTML Help formats. The HTML Help format documentation is fully searchable and cross referenced. The SQL Documentation Tool documents SQL Server Tables, Views, Stored Procedures, Triggers and Table Relationships.</td>
</tr>
<tr>
<td width="100%" valign="top">
<a
href="http://www.winnershtriangle.com/w/SQLDocumentationTool/Reports/Test_Project/Test_Project.chm"><img
src="images/Icon_CHM.gif" width="16" height="16" alt="View Sample Output (HTML Help format)"
border="0" align="absmiddle"></a> <a
href="http://www.winnershtriangle.com/w/SQLDocumentationTool/Reports/Test_Project/Test_Project.chm" title="View Sample Output (HTML Help format)">View Sample
Output</a> (HTML Help format).<br>
<a
href="http://www.winnershtriangle.com/w/SQLDocumentationTool/Reports/Test_Project/Default.htm"><img
src="images/Icon_HTML.gif" width="16" height="16" alt="View Sample Output (HTML Format)"
align="absmiddle" border="0"></a> <a
href="http://www.winnershtriangle.com/w/SQLDocumentationTool/Reports/Test_Project/Default.htm"
target="_blank" title="View Sample Output (HTML Format)">View Sample Output</a> (HTML Format).<br>
<a
href="http://www.brettb.com/redirector.asp?URL=downloads/SQLDocumentationToolTrial.zip"><img
src="images/Icon_Download.gif" width="18" height="20" alt="Download Trial Version"
border="0" align="absmiddle"></a> <a
href="http://www.brettb.com/redirector.asp?URL=downloads/SQLDocumentationToolTrial.zip" title="Download Trial Version">Download
Trial Version</a> (10.3Mb ZIP file).</td>
</tr>
</table>
<br>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="100%" valign="top"><a
href="http://www.winnershtriangle.com/w/Products.IndexServerCompanion.asp" target="_blank" title="Index Server Companion"><strong>Index Server Companion</strong></a></td>
</tr>
<tr>
<td width="100%" valign="top">
The Index Server Companion is a Windows application that extends the functionality of Microsoft Index Server so that it is able to index content from remote websites and also from ODBC databases. As such it can be used as a low cost alternative to Site Server 3.0 Search.
</td>
</tr>
<tr>
<td width="100%" valign="top">
<a
href="http://www.brettb.com/redirector.asp?URL=downloads/IndexServerCompanionDocumentation.zip"><img
src="images/Icon_CHM.gif" width="16" height="16" alt="View Product Documentation"
border="0" align="absmiddle"></a> <a
href="http://www.brettb.com/redirector.asp?URL=downloads/IndexServerCompanionDocumentation.zip" title="View Product Documentation">View Product
Documentation</a> (119K ZIP file).<br>
<a
href="http://www.winnershtriangle.com/w/Products.IndexServerCompanion.SampleSearch.asp"><img
src="images/Icon_HTML.gif" width="16" height="16" alt="Try Sample Search Facility"
align="absmiddle" border="0"></a> <a
href="http://www.winnershtriangle.com/w/Products.IndexServerCompanion.SampleSearch.asp"
target="_blank" title="View Sample Search Facility">Try Sample Search Facility</a>.<br>
<a
href="http://www.brettb.com/redirector.asp?URL=downloads/IndexServerCompanion_EvaluationVersion.zip"><img
src="images/Icon_Download.gif" width="18" height="20" alt="Download Trial Version"
border="0" align="absmiddle"></a> <a
href="http://www.brettb.com/redirector.asp?URL=downloads/IndexServerCompanion_EvaluationVersion.zip" title="Download Trial Version">Download
Trial Version</a> (1.7Mb ZIP file).</td>
</tr>
</table>
<br>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="100%" valign="top"><a
href="http://www.winnershtriangle.com/w/Products.TheWebsiteUtility.asp" target="_blank" title="The Website Utility"><strong>The Website Utility</strong></a></td>
</tr>
<tr>
<td width="100%" valign="top">The Website Utility examines websites for errors and
areas that need to be optimised for search engines by using a built in web crawling engine.
Errors checked for include broken or moved hyperlinks, missing page titles and missing meta tags.
It also generates HTML for use in creating website site maps (table of contents pages - like <a href="http://authors.aspalliance.com/brettb/TableOfContents.asp" title="Example Table of Contents">this one</a>), and is
able to create both client-side <a href="http://www.winnershtriangle.com/w/Products.TheWebsiteUtility.JavaScriptSearchEngine.asp" title="JavaScript Search Engine">JavaScript Search Engines</a> and server-side <a href="http://www.winnershtriangle.com/w/Products.TheWebsiteUtility.ASPSearchEngine.asp" title="JavaScript Search Engine">ASP Search Engines</a> for a website.</td>
</tr>
<tr>
<td width="100%" valign="top">
<a href="http://www.winnershtriangle.com/w/TheWebsiteUtility/Reports/ActiveHealthImaging/ActiveHealthImaging.chm"><img
src="images/Icon_CHM.gif" width="16" height="16" alt="View Sample Output (HTML Help format)"
border="0" align="absmiddle"></a> <a
href="http://www.winnershtriangle.com/w/TheWebsiteUtility/Reports/ActiveHealthImaging/ActiveHealthImaging.chm" title="View Sample Output (HTML Help format)">View Sample
Output</a> (HTML Help format).<br>
<a
href="http://www.winnershtriangle.com/w/TheWebsiteUtility/Reports/ASPAlliance/default.htm"><img
src="images/Icon_HTML.gif" width="16" height="16" alt="View Sample Output (HTML Format)"
align="absmiddle" border="0"></a> <a
href="http://www.winnershtriangle.com/w/TheWebsiteUtility/Reports/ASPAlliance/default.htm"
target="_blank" title="View Sample Output (HTML Format)">View Sample Output</a> (HTML Format).<br>
<a
href="http://www.brettb.com/redirector.asp?URL=downloads/TheWebsiteUtilityTrial.zip"><img
src="images/Icon_Download.gif" width="18" height="20" alt="Download Trial Version"
border="0" align="absmiddle"></a> <a
href="http://www.brettb.com/redirector.asp?URL=downloads/TheWebsiteUtilityTrial.zip" title="Download Trial Version">Download
Trial Version</a> (3Mb ZIP file).</td>
</tr>
</table>
</div>
</td>
<td width="100" valign="top" align="left">
<script type="text/javascript"><!--
google_ad_client = "pub-7044749527879330";
google_ad_width = 120;
google_ad_height = 600;
google_ad_format = "120x600_as";
google_ad_channel ="0956568640";
google_ad_type = "text_image";
google_color_border = "CCCCCC";
google_color_bg = "FFFFFF";
google_color_link = "0000FF";
google_color_url = "DD3333";
google_color_text = "000000";
google_alternate_ad_url = "http://www.brettb.com/NoGoogleAds.asp";
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
<a href="http://www.winnershtriangle.com/w/Products.ASPDocumentationTool.asp"><img
src="http://authors.aspalliance.com/brettb/images/ASPDocumentationTool_1.gif" width="120"
height="60" alt="ASP Documentation Tool - Free Trial Available!" border="0"></a>
<br>
<p align="center"><a href="http://www.jdoqocy.com/lp75gv30v2IKPMSMNLIRLRPNMQ" target="_blank" onmouseover="window.status='http://www.lunarpages.com';return true;" onmouseout="window.status=' ';return true;">
<img src="http://www.awltovhc.com/3a74r6Az42OQVSYSTROXRXVTSW" alt="1000MB and 40GB for $7.95 a month!" border="0"></a></p>
<iframe marginwidth="0" marginheight="0" src="http://rcm.amazon.com/e/cm?t=brettbcom&o=1&p=10&l=st1&mode=books&search=asp&=1&fc1=&lc1=<1=&bg1=&f=ifr" width="130" height="460" border="0" frameborder="0" style="border:none;" scrolling="no"></iframe>
</td>
</tr>
</table>
</center></div>
<div align="center"><center>
<table border="0" cellpadding="2" cellspacing="0" width="802"
style="border: 1px solid rgb(0,0,0)">
<tr>
<td class="TDFooter"> <a href="toc.asp" title="Site Map">Site Map</a></td>
<td class="TDFooter"><p align="right">All content is © 1995 - 2006 Brett Burridge</td>
</tr>
</table>
</center></div>
</body>
</html>