[thelist] WEB APP EFFICIENCY: how to determine

Wade Armstrong wade_lists at runstrong.com
Tue Jun 25 15:43:01 CDT 2002

on 6/25/02 11:01 AM, Chris W. Parker at cparker at swatgear.com wrote:
> are there any tools that can be installed, or that come with win2k
> advanced server already that i can use to judge this?

You can use Microsoft's Web Application Stress Tool (formerly Homer),
http://webtool.rte.microsoft.com/, although I'm not sure I'd recommend
trying that on a production system or a shared server.

> 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.
> btw, i'm using iis5, vbscript.

Other people have commented insightfully on the problems, from a DBMS
standpoint, that SELECT * causes. From a programming standpoint, it also
means that the programmers couldn't have used .GetRows
(http://www.aspfaqs.com/ASPScripts/PrintFAQ.asp?FAQID=161) or .GetString
(http://www.aspfaqs.com/ASPScripts/PrintFAQ.asp?FAQID=113) to handle the
data. In many cases, these techniques are faster and more robust than
dealing with recordsets.


More information about the thelist mailing list