quote:

---

The Server Side Variables collection is built dynamically by IIS the 1st time it is referenced on a page. If you can capture value of key server side variables (such as browser type etc) on your page once and then propagate them via another method, you can gain a performance increase.

Likewise the MapPath() method is expensive. Consider, capturing the path of the root web in an application variable for re-use on all of your pages. The MapPath() call implicitly causes the Server Variables collection to be built.

Use the Len() function to test for empty strings. Much faster.
Slow:
If strX <> "" then

Faster:
If len(strX) > 0 then

When setting an error trap using On Error Resume Next make sure to turn it off as soon as possible with On Error Goto 0
This is obvious but not very well coded in Snitz v3.3.x

If you need to fetch records from multiple queries serially, then use the following technique:

mySQL = "Select * From A;Select * From B" 'Notice the two queries separated by a semi-colon (;)
Create your record set... The recordset object will point to the 1st cursor. Then use
rs.NextRecordset
This moves to the next cursor. You can not go back to make sure you have done all that you need to with the 1st cursor. This technique is much faster and more resource efficient then using multiple recordsets or the same one serially.
I'm not sure if I understand this

---

quote:

---

Can't say I understand what setting the error goto 0 line will do.

---

quote:

---

quote:

---

Can't say I understand what setting the error goto 0 line will do.

---

If you enable trapping errors with On Error Resume Next, the On Error Goto 0 turns trapping off again.


======
Doug G
======

---

That's for sure .

The problem here is that it must be very well organized. The worst way of doing it is to turn error checking off at the beginning of an ASP file and turning it off at the end, turn it on/off in a mysterious place. This also completely disables the programmer's debugging capabilities.

That was what I meant with my green coded comment. I'm not sure with v3.4, but I'm never satisfied with the way it is in inc_profile.asp related stuff.


Think Pink
==> Start Internationalization Here

quote:

---

Slower: (one per line)
Response.Write Name & "<br>"
Response.Write Street & "<br>"
Response.Write City & ", " & State & ", " & Zip & "<br>"

A little faster (de-reference the object) :
With Response
.write Name & "<br>"
.write Street & "<br>"
.write City & ", " & State & ", " & Zip & "<br>“
End With

Faster: (Concatenate strings)
Dim strHTML
strHTML = strHTML & Name & "<br>"
strHTML = strHTML & Street & "<br>"
strHTML = strHTML & City & ", " & State & ", " & Zip & "<br>“
Response.Write strHTML

Faster Still (Use continuation character):
Response.Write Name & "<br>" & _
Street & "<br>" & ", " & _
State & ", " & _
Zip & "<br>"

Even Faster (all on one line):
Response.Write Name & "<br>" & Street & "<br>" & ", " & State & ", " & Zip & "<br>"

---