ASP Performance

[smbure]

I have seen Microsoft Articles and VB articles referring to ASP and/or VB string concatenation as very slow compared to usng the response.write method.

SLOW:
var = var & "stuff"
response.write var

FAST:
response.write var

This is true.

I have done some large recordset performnce testing on the write method vs. string continuation/concatenation and found unexpected results (10000 records).

'rsStuff is a recordset

SLOW:
Response.write "stuff"
Response.write rsStuff
Response.write "more stuff"

FAST:
Response.write "stuff" & rsStuff & "more stuff"

What's the gig?

smbure

App Background: The application is actually writing xml stings in an asp document called by a client side xmldoc. The need to build the xml was because we are using SQL Server 6.5 still...ouch!!

 

[smbure]

One last clarification, those methods are wrapped in a while wend loop and iterates through the recordset...