Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Microsoft: ASP (Active Server Pages) FAQ


How can I improve Performance of my website ? by RushiShroff
Posted: 11 Apr 02

1) Keep database connections down to as few and as quick as possible,
2) Cache frequently requested (but infrequently changed) data, such as site images,
3) Never try and cache connections (or ANY objects) in either session or application state,
4) Avoid using unneeded objects, and unneeded loops...

Connection pooling is handled automatically by IIS as far as I know.  Never store connection objects in session or application state, as this stops IIS from pooling connections, and your site will keel over very quickly.

Try and use stored procedures, when possible.  Create objects as late as possible, and destroy them as quickly.  Use the .GetRows() or .GetString() methods to format data, rather than looping through a recordset, and close and destroy the objects.

Set up commonly requested data as cached, or manually cache some dynamic data in static HTML files which can be sourced off to the user, rather than negotiating with the database.  Set IIS up to cache images for as long as is possible.

However, the most important thing to remember is the bandwidth.  If you don't consider that, your application will severely be hindered.

Courtesy : Mr Craig(www.AspMessageBoard.com)

Back to Microsoft: ASP (Active Server Pages) FAQ Index
Back to Microsoft: ASP (Active Server Pages) Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close