ASP Performance

[Roland Hall]

I've read numerous articles, more than I can count, on ASP performance. I
see conflicting information so I did some tests on my own.

getstring and getrows are actually faster than recordset looping.

However, I've read in looping that Do While...Loop is the fastest and
For...Next the slowest but my tests prove otherwise.

I've tested:
Do...Loop
Do While...Loop
Do Until...Loop
While...Wend
For...Next

I didn't think I could do an accurate test with For...Each unless I used a
collection or an array.

I also see conflicting information on string concatenation and
Response.Write

Is this better?

dim str
str = str & "this "
str = str & "that "
str = str & "this and that"
Response.Write str

or this?

dim str
Response.Write "this "
Response.Write "that "
Response.Write "this and that"

I've also seen to speed the last one up:

with Response
.Write "this "
.Write "that "
.Write "this and that"
end with

Are there reliable performance tests that can be reviewed?
Does it vary between languages? ASP:VBscript, ASP:JScript, C/C++, Delphi,
VB, C#

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp

[dlbjr]

Why not use something like the code below to set row style:
No Mod Check or any heavy processing code needed.

Function GetRowStyle(str 1)

Select Case str1
Case "Style1"
GetRowStyle = "Style2"
Case Else
GetRowStyle = "Style1"
End Select
End Function
PS. The Getrows() is the way to go with the data.

'dlbjr
'Pleading sagacious indoctrination!

[Dave Anderson]

"Roland Hall" wrote:

You saying, in that thread that this:

dim arr
arr = Array("A","B"," C")

is significantly better than...

dim arr
arr = split("A,B,C"," ,")

Where is the threshold where it becomes noticeable?

This is not an ASP question.

It's being used on a web page with a .asp extension between
<% and %>. What would you label it?

VBScript, obviously.
--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.

[Dave Anderson]

"Roland Hall" wrote:

No, because that just leads to more analysis. What if you flush the
buffer after every write? How about after every Nth write? Tedious.
My goodness Dave. Obviously I'm not wanting to double processing in
hopes of decreasing latency. However, perhaps there is a potential
for an increase in performance by flusing the buffer every now and
then. Saying it's not worth considering because it requires more
analysis dosen't seem like a worthwhile response.

By "tedious", I was referring to doing more analysis. You asked if I
happened to do that analysis, and my answer was: "No, because that would
require a lot more than a single simple observation."

I don't really see what your beef is.

...How can I take adavantage of getRows with iteration where I want
cosmetic differences in the results...

...If is use getrows and want every other background a different color,
I have use a MOD or something to determine which will have a negative
impact on the advantage of using getrows.

It seems you already know the answer to your question.

...I'm still using For...Next loops, which will require a decision to
determine which row is which...

Does it really? Here's an alternative with no "decision":

<style>
tr.row0 { background-color:#fff }
tr.row1 { background-color:#eee }
</style>
<% for (i=0; i<ary.length; i++) { %>
<tr class="row<%=i% 2%>"> ...

Here's another:

<% var colors=["#fff","#ee e"]
for (i=0; i<ary.length; i++) { %>
<tr stlye="backgrou nd-color:<%=colors[i%2]%>"> ...
--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.

[dlbjr]

It is best to use tags as such in asp:

<script language="VBScr ipt" runat="Server">

</script>

<script language="javas cript" runat="Server">

</script>

This allows a mixed use (if needed) of multiple languages on as single page.
No dependency on the Default Language setting in IIS.
Assuming the server is set to VBScript is a false assumption.
Moving pages from one server to another can fail.

Using Tags as such:

<% %>

Assumes the default language is set to what you are using.
You should at least clarify the language at the top of the asp.

'dlbjr
'Pleading sagacious indoctrination!

[Roland Hall]

"Bob Barrows [MVP]" wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. ..
: Roland Hall wrote:
: >
: > If is use getrows and want every other background a different color,
: > I have use a MOD or something to determine which will have a negative
: > impact on the advantage of using getrows.
:
: But it still beats the alternative of looping through your recordset.

Yes, I would agree. I read a document that says getrows sometimes,
getstring sometimes AND recordset loops sometimes but not sure where I read
it. It was either aspfaqs.com or 4guysfromrolla. com, which I think is run
by the same people.

Would you agree that recordset loops can be used sometimes?

: > At this point getstring
: > seems to have a disadvantage since it uses markup as parameters.
: > There is nothing that says, use all even or all odd rows with
: > different markup.
: >
: > If the comparison is only for a drab layout, then it's not that
: > realistic except perhaps to an accountant. I'm still using
: > For...Next loops, which will require a decision to determine which
: > row is which unless you use alternating loops separating odd and even
: > and that seems to be bad alternative.
:
:
: Or you could incorporate some of that logic into the query that produces
the
: resultset.
: Perhaps a computed column that indicates the color to be used for a row
....

A computer column that returns a hex value?

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp

[Roland Hall]

"dlbjr" wrote in message news:Ok******** ******@tk2msftn gp13.phx.gbl...
: Why not use something like the code below to set row style:
: No Mod Check or any heavy processing code needed.

But it's still a decision tree, is it not? Does SELECT...CASE perform
better than IF...THEN?

: Function GetRowStyle(str 1)
:
: Select Case str1
: Case "Style1"
: GetRowStyle = "Style2"
: Case Else
: GetRowStyle = "Style1"
: End Select
: End Function
:
:
: PS. The Getrows() is the way to go with the data.

As a primary or a constant solution? I'm trying to narrow down and document
what will perform best for a given situation.

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp

[Roland Hall]

"Dave Anderson" wrote in message news:11******** *****@corp.supe rnews.com...
: "Roland Hall" wrote:
: >> No, because that just leads to more analysis. What if you flush the
: >> buffer after every write? How about after every Nth write? Tedious.
: >
: > My goodness Dave. Obviously I'm not wanting to double processing in
: > hopes of decreasing latency. However, perhaps there is a potential
: > for an increase in performance by flusing the buffer every now and
: > then. Saying it's not worth considering because it requires more
: > analysis dosen't seem like a worthwhile response.
:
: By "tedious", I was referring to doing more analysis. You asked if I
: happened to do that analysis, and my answer was: "No, because that would
: require a lot more than a single simple observation."
:
: I don't really see what your beef is.

I'm trying to draw knowledge from the well and you're telling me it's too
hard to bring the bucket to the top. (O:=

: >>> ...How can I take adavantage of getRows with iteration where I want
: >>> cosmetic differences in the results...
: >
: > ...If is use getrows and want every other background a different color,
: > I have use a MOD or something to determine which will have a negative
: > impact on the advantage of using getrows.
:
: It seems you already know the answer to your question.

It shouldn't because I don't. I'm posing these questions to gain knowledge
because I may not have considered some variables and there are people here a
lot better at this than I am.

: > ...I'm still using For...Next loops, which will require a decision to
: > determine which row is which...
:
: Does it really? Here's an alternative with no "decision":
:
: <style>
: tr.row0 { background-color:#fff }
: tr.row1 { background-color:#eee }
: </style>
: <% for (i=0; i<ary.length; i++) { %>
: <tr class="row<%=i% 2%>"> ...
:
: Here's another:
:
: <% var colors=["#fff","#ee e"]
: for (i=0; i<ary.length; i++) { %>
: <tr stlye="backgrou nd-color:<%=colors[i%2]%>"> ...

Ok, that's helpful. Thank you.

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp

[Bob Barrows [MVP]]

Roland Hall wrote:

"Bob Barrows [MVP]" wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. ..

Roland Hall wrote:

If is use getrows and want every other background a different color,
I have use a MOD or something to determine which will have a
negative impact on the advantage of using getrows.
But it still beats the alternative of looping through your recordset.

Yes, I would agree. I read a document that says getrows sometimes,
getstring sometimes AND recordset loops sometimes but not sure where
I read it. It was either aspfaqs.com or 4guysfromrolla. com, which I
think is run by the same people.

It was this article on aspfaq:
http://www.aspfaq.com/show.asp?id=2467

Would you agree that recordset loops can be used sometimes?

Yes, for things like subtotals, grouping, etc. But always disconnect them
first.

At this point getstring
seems to have a disadvantage since it uses markup as parameters.
There is nothing that says, use all even or all odd rows with
different markup.
Right

If the comparison is only for a drab layout, then it's not that
realistic except perhaps to an accountant. I'm still using
For...Next loops, which will require a decision to determine which
row is which unless you use alternating loops separating odd and
even and that seems to be bad alternative

Or you could incorporate some of that logic into the query that
produces the resultset.
Perhaps a computed column that indicates the color to be used for a
row ...

A computer column that returns a hex value?

Sure, why not? or a color in plain English. Or a flag to be read by your
loop. Of course, your data source has to be set up so that this logic can be
applied by the sql statement.

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[dlbjr]

Yes! A SELECT...CASE will perform far better than IF...THEN
Constant! I use GetRows() exclusively when looping through data.

'dlbjr
'Pleading sagacious indoctrination!

[Roland Hall]

"Bob Barrows [MVP]" wrote in message
news:%2******** ********@TK2MSF TNGP14.phx.gbl. ..
: Roland Hall wrote:
: > "Bob Barrows [MVP]" wrote in message
: > news:%2******** ********@tk2msf tngp13.phx.gbl. ..
: >> Roland Hall wrote:
: >>>
: >>> If is use getrows and want every other background a different color,
: >>> I have use a MOD or something to determine which will have a
: >>> negative impact on the advantage of using getrows.
: >>
: >> But it still beats the alternative of looping through your recordset.
: >
: > Yes, I would agree. I read a document that says getrows sometimes,
: > getstring sometimes AND recordset loops sometimes but not sure where
: > I read it. It was either aspfaqs.com or 4guysfromrolla. com, which I
: > think is run by the same people.
:
: It was this article on aspfaq:
: http://www.aspfaq.com/show.asp?id=2467

That may be the one.

: > A computer column that returns a hex value?
:
: Sure, why not? or a color in plain English. Or a flag to be read by your
: loop. Of course, your data source has to be set up so that this logic can
be
: applied by the sql statement.

I was only verifying. A different approach than I have used. I'm sure I'll
find all kinds of performance gains if I spend more time on SPs and looking
at SQL alternatives.

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp