[thelist] WEB APP EFFICIENCY: how to determine

[Chris W. Parker]

hi.

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
client.

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
things.

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.


thanks,
chris.