Using Web Assistant to Improve performance of ASP Pages

By Bill Graziano on 22 June 2000 | Tags: Performance Tuning


This article, by Venkatraman Ambethkar, demonstrates how use the SQL Server 7 Web Assistant to speed up your ASP pages! The SQL Server Web Assistant can be used to create a static view of your database tables. If your database contains information that doesn't change extremely often, this approach provides better performance than continually hitting the database each time you wish to display database table information.

Link: Using Web Assistant to Improve performance of ASP Pages


Related Articles

Which is Faster: SAN or Directly-Attached Storage? (21 January 2008)

Benchmarking Disk I/O Performance: Size Matters! (30 October 2007)

What I Wish Developers Knew About SQL Server (Presentation) (11 October 2007)

Introduction to Parameterization in SQL Server (7 August 2007)

Using Indexed Computed Columns to Improve Performance (16 January 2007)

SQL Server Storage Engine Team Blog (7 June 2006)

Statistics Used by the Query Optimizer in Microsoft SQL Server 2005 (1 June 2005)

Improving .NET Application Performance and Scalability (29 April 2004)

Other Recent Forum Posts

How can I get just the latest row? (6h)

To find last next value on the basis of Current and next row values in Sql server 2008 (12h)

Migrate 2008R2 FCI to 2016 AOAG (23h)

Parse the values into multiple columns (23h)

SQL 2017 MLS - cant add python packages (1d)

Number weeks from April to September for every year (2d)

Today date -1 year (2d)

To get Total Hour & Late Hour from Time In, Time Out, 1st Break & 2nd Break (3d)

- Advertisement -