[thelist] WEB APP EFFICIENCY: how to determine

Robert Goodyear rob_goodyear at yahoo.com
Tue Jun 25 13:28:01 CDT 2002


I can answer one piece definitively for you...

Select * is extremely inefficient as all the
fieldnames must be queried from the DB and returned
before the data starts to come over. With a named
SELECT, that entire process is skipped.

Also, Chris, if in your research you happen to come
across an answer for my previous TheList question
about the relative efficiency of FSO vs. DB Lookups,
let me know, willya!

Thanks.

/rg

Robert Goodyear
http://www.westeye.com

--- "Chris W. Parker" <cparker at swatgear.com> wrote:
> 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.
> --


__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com



More information about the thelist mailing list