Source Code for http://authors.aspalliance.com/brettb/ASPDataCaching.asp
<html>
<!--Begin ASPAlliance Document Header-->
<head>
<title>Improving ASP Performance With Data Caching</title>
<link type="text/css" rel="stylesheet" href="ASPKitchen.css" />
<meta name="description" content="Sample VBScript (ASP) code showing how to improve website performance by caching database data">
<meta name="keywords" content="ASP, sql, microsoft access, performance, enhancement, faster">
</head>
<!--Begin ASPAlliance Document Article-->
<body topmargin="0" leftmargin="0">
<div align="center"><center>
<script language="JavaScript">
function SubmitSearch() {
document.frmSearch.submit();
}
</script>
<table border="0" cellpadding="0" width="100%" cellspacing="0">
<tr>
<td width="30%" bgcolor="#CC0000"><a href="http://authors.aspalliance.com/"><img
src="images/ASPAllianceLogo.gif" width="142" height="57" alt="ASPAlliance" border="0"></a></td>
<td width="40%" bgcolor="#CC0000" align="center"><!-- 468x60 Banner Ad Tag Start -->
<iframe src="http://ads.aspalliance.com/displayad.aspx?t=1&m=1" height="60" width="468" marginwidth="0" marginheight="0" frameborder="0" scrolling="no"><script type="text/javascript" src="http://ads.aspalliance.com/displayad.aspx?t=1&m=1&target=_parent&js=1"></script></iframe>
<!-- 468x60 Banner Ad Tag End --></td>
<td width="30%" bgcolor="#CC0000" align="right" class="HeaderBar"><font size="4">ASP Kitchen</font> <br><form name="frmSearch" method="POST" action="http://www.brettb.com/ASPAllianceSearch.asp">Search: <input type="text" name="Query"> <a href="javascript:SubmitSearch()">Go</a> </form>
</td>
</tr>
<tr>
<td colspan="3" bgcolor="#CCCCCC" style="BORDER: #270D30 1px solid;"><div class="menu-top"
id="TopMenu" align="left"><a href="Default.asp" title="Home"><p>Home</a> | <a
href="ClassicASPArticles.asp" title="ASP Articles">ASP Articles</a> | <a
href="ASP.NetArticles.aspx" title="ASP.NET Articles">ASP.NET Articles</a> | <a
href="Tools.asp" title="Tools">Tools</a> | <a
href="TableOfContents.asp" title="Table Of Contents">Table Of Contents</a> | <a href="What'sNew.aspx" title="What's New">What's
New</a></p>
</div></td>
</tr>
</table>
</center></div>
<table border="0" cellpadding="8" width="100%" cellspacing="0">
<tr>
<td valign="top" align="left"><!--start article-->
<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>
<h2>An Example of ASP Data Caching</h2>
<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><small><font color="blue">Application</font>("CachingDuration") = 120 <br>
<a name="3"></a><font color="blue">Application</font>("PopularProductsHTML") =
"" <br>
<a name="4"></a><font color="blue">Application</font>("PopularProductsHTML.LastModified")
= <font color="blue">Now</font>()</small></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><small><%</span> <br>
<a name="8"></a><font color="blue">Function</font> <font color="#FF00FF">GetPopularProductsHTML</font>(NumberOfProducts)
<br>
<a name="9"></a> <br>
<a name="10"></a> <font color="blue">On</font> <font color="blue">Error</font>
<font color="blue">Resume</font> <font color="blue">Next</font> <br>
<a name="11"></a> <font color="blue">Dim</font> DataConnection <br>
<a name="12"></a> <font color="blue">Dim</font> RecordSet <br>
<a name="13"></a> <font color="blue">Dim</font> SQL <br>
<a name="14"></a> <font color="blue">Dim</font> ReturnString <br>
<a name="15"></a> <font color="blue">Dim</font> ProductName <br>
<a name="16"></a> <font color="blue">Dim</font>
NumberOfProductsDisplayed <br>
<a name="17"></a> <br>
<a name="18"></a><font color="green"> 'Access Query for returning
popular products </font><br>
<a name="19"></a> SQL = "sp_GetPopularProducts" <br>
<a name="20"></a> <br>
<a name="21"></a> <font color="blue">Set</font> DataConnection = <font
color="blue">Server.CreateObject</font>("<font color="#800000">ADODB.connection</font>")
<br>
<a name="22"></a> DataConnection.Open <font color="blue">Application</font>("ConnectionString")
<br>
<a name="23"></a> <br>
<a name="24"></a> <font color="blue">Set</font> RecordSet = <font
color="blue">Server.CreateObject</font>("<font color="#800000">ADODB.Recordset</font>")
<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> <font color="blue">Do</font> <font color="blue">While</font>
Not RecordSet.EOF <br>
<a name="31"></a> <br>
<a name="32"></a> <font
color="blue">If</font> NumberOfProductsDisplayed < NumberOfProducts <font color="blue">Then</font>
<br>
<a name="33"></a> <br>
<a name="34"></a> ProductName
= <font color="blue">Replace</font>(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> <font
color="blue">End</font> <font color="blue">If</font> <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> <font color="blue">Loop</font> <br>
<a name="44"></a> <br>
<a name="45"></a> RecordSet.Close <br>
<a name="46"></a> <font color="blue">Set</font> RecordSet = <font
color="blue">nothing</font> <br>
<a name="47"></a> DataConnection.Close <br>
<a name="48"></a> <font color="blue">Set</font> DataConnection = <font
color="blue">nothing</font> <br>
<a name="49"></a> <br>
<a name="50"></a> GetPopularProductsHTML = ReturnString <br>
<a name="51"></a> <br>
<a name="52"></a><font color="blue">End</font> <font color="blue">Function</font> <br>
<a name="53"></a><span style="background-color: #FFFF66">%></span> </small></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><small><%</span> <br>
<a name="56"></a><font color="blue">Dim</font> PopularProductsBoxTitleText <br>
<a name="57"></a><font color="blue">Dim</font> PopularProductsBoxContentsText <br>
<a name="58"></a><font color="blue">Dim</font> 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><font color="green">'If cache is empty then retrieve data from the
database </font><br>
<a name="64"></a><font color="blue">If</font> <font color="blue">Application</font>("PopularProductsHTML")
= "" <font color="blue">Then</font> <br>
<a name="65"></a> <br>
<a name="66"></a> PopularProductsBoxContentsText = <font
color="#FF00FF">GetPopularProductsHTML</font>(NumberOfProducts) <br>
<a name="67"></a> <br>
<a name="68"></a> <font color="blue">Application.Lock</font>() <br>
<a name="69"></a> <font color="blue">Application</font>("PopularProductsHTML")
= PopularProductsBoxContentsText <br>
<a name="70"></a> <font color="blue">Application</font>("PopularProductsHTML.LastModified")
= <font color="blue">Now</font>() <br>
<a name="71"></a> <font color="blue">Application.UnLock</font>() <br>
<a name="72"></a> <br>
<a name="73"></a><font color="green">'Retrieve content directly from the cache instead of
the database </font><br>
<a name="74"></a><font color="blue">Else</font> <br>
<a name="75"></a> PopularProductsBoxContentsText = <font
color="blue">Application</font>("PopularProductsHTML") <br>
<a name="76"></a> <br>
<a name="77"></a><font color="green"> 'Is the cache out of date? If
so retrieve the content from the database and store in the cache </font><br>
<a name="78"></a><font color="green"> 'The VBScript DateDiff
function can be used to compare dates (n = comparisons of minutes) </font><br>
<a name="79"></a> <font color="blue">If</font> <font color="blue">DateDiff</font>("n",
Application("PopularProductsHTML.LastModified"), Now()) >
Application("CachingDuration") <font color="blue">Then</font> <br>
<a name="80"></a> <font color="blue">Response.Write</font>("<!--Cache
Updated-->")<font color="green"> 'Useful debugging line - remove from production
code </font><br>
<a name="81"></a> PopularProductsBoxContentsText
= <font color="#FF00FF">GetPopularProductsHTML</font>(NumberOfProducts) <br>
<a name="82"></a> <br>
<a name="83"></a><font color="green"> 'Store
the content in the Application variables. </font><br>
<a name="84"></a> <font color="blue">Application.Lock</font>()
<br>
<a name="85"></a> <font
color="blue">Application</font>("PopularProductsHTML") =
PopularProductsBoxContentsText <br>
<a name="86"></a> <font
color="blue">Application</font>("PopularProductsHTML.LastModified") = <font
color="blue">Now</font>() <br>
<a name="87"></a> <font color="blue">Application.UnLock</font>()
<br>
<a name="88"></a> <br>
<a name="89"></a> <font color="blue">End</font> <font color="blue">If</font>
<br>
<a name="90"></a> <br>
<a name="91"></a><font color="blue">End</font> <font color="blue">If</font> <br>
<a name="92"></a> <br>
<a name="93"></a><font color="green">'Display the popular products box </font><br>
<a name="94"></a><font color="blue">If</font> PopularProductsBoxContentsText <>
"" <font color="blue">Then</font> <br>
<a name="95"></a><span style="background-color: #FFFF66">%></span> <br>
<a name="96"></a> <div class="BoxOutline"> <br>
<a name="97"></a> <div
class="BoxTitle"> <br>
<a name="98"></a> <span
class="PopularProductsBoxTitleText"><span style="background-color: #FFFF66"><%</span>=PopularProductsBoxTitleText<span
style="background-color: #FFFF66">%></span></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> <span
style="background-color: #FFFF66"><%</span>=PopularProductsBoxContentsText<span
style="background-color: #FFFF66">%></span> <br>
<a name="103"></a> </span>
<br>
<a name="104"></a> </div> <br>
<a name="105"></a> </div> <br>
<a name="106"></a><span style="background-color: #FFFF66"><%</span> <br>
<a name="107"></a><font color="blue">End</font> <font color="blue">If</font> <br>
<a name="108"></a><span style="background-color: #FFFF66">%></span> </small></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>
<h2>When to use ASP Caching</h2>
<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>
<h2>Links</h2>
<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 ASP syntax highlighting and color coding used in this article was created using the <a
href="http://www.winnershtriangle.com/w/Products.ASPDocumentationTool.asp"
title="ASP Documentation Tool">ASP Documentation Tool</a>.</li>
</ul>
<!--end article-->
<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.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.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> (727K 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.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="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/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>
<br>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="100%" valign="top"><a
href="http://www.regnow.com/softsell/nph-softsell.cgi?item=8452-18&affiliate=44172" target="_blank" title="Text Workbench"><strong>Text Workbench</strong></a></td>
</tr>
<tr>
<td width="100%" valign="top">Text Workbench is a file search and replacement utility for text files and Microsoft Office documents. Make rapid file replacements on multiple files and folders full of files. Advanced replacement options include regular expressions support. It even works on remote file systems via FTP. A Regular Expression Laboratory allows advanced pattern matching and replacement expressions to be built and tested. This great utility will make your everyday development tasks much easier!
</td>
</tr>
<tr>
<td width="100%" valign="top">
<a
href="http://www.regnow.com/trialware/download/Download_TxtWrBSetup.exe?item=8452-18&affiliate=44172"><img
src="images/Icon_Download.gif" width="18" height="20" alt="Download Trial Version of Text Workbench"
border="0" align="absmiddle"></a> <a
href="http://www.regnow.com/trialware/download/Download_TxtWrBSetup.exe?item=8452-18&affiliate=44172" title="Download Trial Version of Text Workbench">Download
Trial Version</a> (3Mb ZIP file; you have the option to either install directly from this link or save the file for later installation).</td>
</tr>
</table>
</div>
<h2>Author details</h2>
<p><p><a href="http://www.brettb.com/" title="View Brett's personal website">Brett Burridge</a>
spent two years working in the <a href="http://www.essex.ac.uk/"
title="University of Essex">University of Essex</a> Computing Service, before moving to <a
href="http://www.intapps.com/" title="The Internet Applications Group">The Internet
Applications Group</a> in the Autumn of 1999, where he developed e-Business applications for a range of
corporate clients and dot-com start ups.</P>
<P>Brett is presently employed as an Internet developer and technical writer
through his own company,
<a href="http://www.winnershtriangle.com/w/Default.asp" title="Winnersh Triangle Web Solutions Limited" target="_blank">Winnersh Triangle Web Solutions Limited</a>.
The company produces a number of
innovative products, including the popular
<a href="http://www.winnershtriangle.com/w/Products.ASPDocumentationTool.asp" target="_blank" title="ASP Documentation Tool™ - creates project documentation for ASP 2.0 and 3.0 websites written in VBScript and JScript, and also SQL Server 2000 databases">ASP Documentation Tool™</a>, the <a href="http://www.winnershtriangle.com/w/Products.IndexServerCompanion.asp" target="_blank" title="Index Server Companion - extends the functionality of Index Server to allow indexing of content from remote websites and ODBC databases">Index Server Companion</a>, the <a href="http://www.winnershtriangle.com/w/Products.ASPNETDocumentationTool.asp" target="_blank" title="ASP.NET Documentation Tool - creates documentation for ASP.NET web applications written in VB.NET and C#">ASP.NET Documentation Tool</a>, the <a href="http://www.winnershtriangle.com/w/Products.SQLServerDocumentationTool.asp" target="_blank" title="SQL Server Documentation Tool - Documents Microsoft SQL Server Databases">SQL Server Documentation Tool</a> and <a href="http://www.winnershtriangle.com/w/Products.TheWebsiteUtility.asp" target="_blank" title="The Website Utility">The Website Utility</a>.
The company is also available for <a href="http://www.winnershtriangle.com/w/Services.Main.asp" target="_blank" title="web application design and development">web application design and development</a> at reasonable rates, primarily using
<a href="http://www.winnershtriangle.com/w/Services.Microsoft.asp" target="_blank" title="Development using Microsoft technologies such as ASP, ASP.NET, Visual Basic, SQL Server">Microsoft technologies</a> (ASP, ASP.NET, Visual Basic, SQL Server) but also using <a href="http://www.winnershtriangle.com/w/Services.OpenSource.asp" target="_blank" title="Open source development using technologies such as PHP, MySQL and Perl">open source</a>
technologies such as PHP, MySQL and Perl. Specialist services include development
of <a href="http://www.winnershtriangle.com/w/Services.IndexServer.asp" target="_blank" title="Development of search solutions using Microsoft's Index Server and Site Server 3.0 Search">search solutions</a> using Microsoft's Index Server and Site Server 3.0 Search.
</P>
<P>
As well as the ASPAlliance, Brett has written articles for <a href="http://www.ariadne.ac.uk/issue33/nt-explorer/" title="Read Brett's most recent article for Ariadne.ac.uk" target="_blank">Ariadne.ac.uk</a>
and <a href="http://www.asptoday.com/content.asp?id=1435" target="_blank" title="Read Brett's first ASPToday article">ASPToday</a>, and has contributed recipes to the <a href="http://www.amazon.com/exec/obidos/ASIN/0672325241/brettbcom" target="_blank" title="ASP.NET Developer's Cookbook">ASP.NET Developer's Cookbook</a>.
<small><a href="Links.asp" style="color: rgb(252,253,253);">links</a></small>
</P>
<p>
Outside web development, Brett is interested in digital photography (here's my <a href="http://www.brettb.com/gallery.asp" target="_blank" title="My digital photo gallery">photo gallery</a>), <a href="http://www.brettb.com/MyTropicalFishtank.asp" target="_blank" title="My Tropical Fish!">tropical fishkeeping</a>
and collecting contemporary works of art by artists such as <a href="http://www.brettb.com/Doug_Hyde_Gallery.asp" title="My Doug Hyde Limited Edition Sculptures and Prints" target="_blank">Doug Hyde</a>.
</p>
<p>Contact Brett by emailing <script language="JavaScript"><!--
document.write('<a title="Email Brett" href="mailto:' + 'brett' + '@asp' + 'alliance.com">brett' + '@' + 'aspalliance.com</a>');
// --></script></p>
<p align="center">
<a href="http://www.winnershtriangle.com/w/Products.IndexServerCompanion.asp?FROM=http://authors.aspalliance.com/brettb/ASPDataCaching.asp" target="_blank"><IMG SRC="images/IndexServerCompanion_468x60_2.gif" width="468" height="60" alt="Index Server Companion - allows Index Server to index content from remote websites and ODBC databases!!!" border="0"></a>
</p>
</p>
<h2>Article history</h2>
<p>"Improving ASP Performance With Data Caching" published on ASPAlliance.com on 16 March
2004, last revised 16 March 2004.</p>
<p><a title="Back to the ASP Kitchen" href="Default.asp">ASP Kitchen</a>: <a
href="ClassicASPArticles.asp">Classic ASP Articles</a>: Improving ASP Performance With Data Caching</p>
</td>
</td>
<td valign="top" align="center" bgcolor="#CCCCCC" style="BORDER-LEFT: rgb(102,102,102) 1px solid;"> <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 ="5708954406";
google_color_border = "0000C0";
google_color_bg = "FFFFFF";
google_color_link = "E60000";
google_color_url = "0000FF";
google_color_text = "000000";
google_ad_type = "text_image";
google_alternate_ad_url = "http://authors.aspalliance.com/brettb/NoGoogleAds.asp";
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
<p align="center">
<a href="http://www.winnershtriangle.com/w/Products.ASPDocumentationTool.asp" target="_blank"><img src="http://authors.aspalliance.com/brettb/images/ASPDocumentationTool_1.gif" alt="Download a Free ASP Documentation Tool Now!"></a>
</p>
<!-- Search Google -->
<center>
<form method="get" action="http://www.google.com/custom" target="google_window">
<table bgcolor="#cccccc">
<tr><td nowrap="nowrap" valign="top" align="left" height="32">
<a href="http://www.google.com/">
<img src="http://www.google.com/logos/Logo_25gry.gif" border="0" alt="Google" align="middle"></img></a>
<br/>
<input type="text" name="q" size="15" maxlength="255" value=""></input>
</td></tr>
<tr><td valign="top" align="left">
<input type="submit" name="sa" value="Search"></input>
<input type="hidden" name="client" value="pub-7044749527879330"></input>
<input type="hidden" name="forid" value="1"></input>
<input type="hidden" name="channel" value="4628523158"></input>
<input type="hidden" name="ie" value="ISO-8859-1"></input>
<input type="hidden" name="oe" value="ISO-8859-1"></input>
<input type="hidden" name="cof" value="GALT:#008000;GL:1;DIV:#336699;VLC:663399;AH:center;BGC:FFFFFF;LBGC:336699;ALC:0000FF;LC:0000FF;T:000000;GFNT:0000FF;GIMP:0000FF;FORID:1;"></input>
<input type="hidden" name="hl" value="en"></input>
</td></tr></table>
</form>
</center>
<!-- Search Google -->
<p align="center">
<a href="http://www.regnow.com/softsell/visitor.cgi?affiliate=44172&action=site&vendor=7522" target="_blank" title="Search Engine Builder - Build a search engine for your website!"><img border="0" src="images/SearchEngineBuilder.gif" alt="Search Engine Builder - Build a search engine for your website!"></a>
</p>
</td>
</tr>
<tr><td bgcolor="#CC0000" colspan="2" style="BORDER-TOP: rgb(102,102,102) 1px solid;"><small><font color="white">© page content copyright Brett Burridge 1998 - 2004.</font></small></td></tr>
</table>
<!--End ASPAlliance Document Article-->
</body>
</html>