[thelist] WEB APP EFFICIENCY: how to determine

Chris W. Parker cparker at swatgear.com
Tue Jun 25 13:02:01 CDT 2002


it's me again. this time i'd like to know how to best determine the
resources used on the server when any certain page is requested by a

for example, one of the include files used (this is a purchased
open-source e-commerce app.) in the application is about 95k. it holds
many different functions and routines. although a lot of them are not
used on every page. each page that includes this source file probably
only uses from 1-10k of the file itself. so i'd like to know what
resources are used when loading a 95k file multiples time in a minute
verses loading a 5k file multiple times in a minute.

also, the programmers also do "SELECT * FROM myTbl..." even when they
only need to reference one field. sometimes the tables are small, but
sometimes they are big. and so i'd like to also determine how much more
efficient it would be to go through and change all those sorts of

are there any tools that can be installed, or that come with win2k
advanced server already that i can use to judge this?

btw, i'm using iis5, vbscript.


More information about the thelist mailing list