原理:每次存取 Request("key") 或 Request.Form("key") 都會搜尋多個集合(QueryString、Form、Cookies、ServerVariables...),效能遠低於區域變數。
If Len(Request.Form("Title")) Then ...
If Request.Form("FirstName") = "" Then ...
If Len(Request.Form("FirstName")) = 1 Then ...
Dim strTitle, strFirstName, strLastName, strFullName
strTitle = Request.Form("Title")
strFirstName = Request.Form("FirstName")
strLastName = Request.Form("LastName")
If Len(strTitle) Then strTitle = strTitle & " "
If strFirstName = "" Then
strFullName = strTitle & strLastName
ElseIf Len(strFirstName) = 1 Then
strFullName = strTitle & strFirstName & ". " & strLastName
Else
strFullName = strTitle & strFirstName & " " & strLastName
End If
避免 Request("page") — 會依序搜尋 QueryString、Form、Cookies、ClientCertificate、ServerVariables。
改用 明確集合:
Request.QueryString("page") — GET 參數Request.Form("page") — POST 表單Request.Cookies("page") — CookieRequest.ServerVariables("SERVER_NAME") — 伺服器變數除非確定某值只可能出現在單一集合,否則請勿使用泛型
Request("key")。這既是效能優化,也是安全防禦(避免同名參數覆蓋)。
在產生大量內容、複雜計算、大檔案串流前,確認用戶端仍在線:
' 產生第一部分內容
' ... 程式碼 ...
If Response.IsClientConnected Then
Response.Flush ' 送出已產生內容
Else
Response.End ' 用戶已離開,釋放資源
End If
' 產生第二部分內容
' ... 程式碼 ...
<%
Response.Buffer = True
' 1. 快取請求參數
Dim dateFrom, dateTo, categoryId
dateFrom = Request.QueryString("from")
dateTo = Request.QueryString("to")
categoryId = Request.QueryString("cat")
' 2. 參數化查詢
Dim cmd, rs
Set cmd = Server.CreateObject("ADODB.Command")
cmd.ActiveConnection = conn
cmd.CommandText = "SELECT * FROM Sales WHERE SaleDate BETWEEN ? AND ? AND CategoryID = ?"
cmd.Parameters.Append cmd.CreateParameter("@d1", 135, 1, , dateFrom) ' adDBTimeStamp
cmd.Parameters.Append cmd.CreateParameter("@d2", 135, 1, , dateTo)
cmd.Parameters.Append cmd.CreateParameter("@cat", 3, 1, , categoryId) ' adInteger
Set rs = cmd.Execute
' 3. 串流輸出 HTML 表格
Response.AddHeader "Content-Type", "text/html; charset=utf-8"
Response.Write "日期 商品 金額 "
Dim rowCount
rowCount = 0
Do While Not rs.EOF
Response.Write ""
Response.Write "" & rs("SaleDate") & " "
Response.Write "" & Server.HTMLEncode(rs("ProductName")) & " "
Response.Write "" & FormatCurrency(rs("Amount")) & " "
Response.Write " "
rowCount = rowCount + 1
' 每 100 列檢查一次連線並 Flush
If rowCount Mod 100 = 0 Then
If Not Response.IsClientConnected Then Exit Do
Response.Flush
End If
rs.MoveNext
Loop
Response.Write "
"
rs.Close: Set rs = Nothing
%>
Timer 函數測量關鍵區塊執行時間。ab (ApacheBench)、wrk、JMeter。