ASP Performance Test Part II (EXT) (ii)

Second, test environment
This test uses a total of 21 ASP files that can be downloaded from the back of this article. Each page is set up to run three different queries, returning 0, 25, and 250 records, respectively. This will help us isolate the initialization of the page itself, the overhead of running it, and the overhead of iterating through recordsets.
For ease of testing, both the database connection string and the SQL command string are saved as application variables in Global.asa. Since our test database is SQL Server 7.0, the connection string specifies OLE DB as the connection provider, and the test data comes from the Northwind database of SQL Server. The SQL Select command extracts 7 specified fields from the Northwind Orders table.
< SCRIPT language=vbscript Runat=server >
Sub Application_OnStart
Application ("Conn") = "Provider=sqloledb;" & _
"Server=myserver;" & _
"UID=SA;" & _
"Pwd=;" & _
"Database=northwind"
Application ("SQL") = "SELECT top 0 OrderID," & _
"CustomerID," & _
"EmployeeID," & _
"OrderDate," & _
"RequiredDate," & _
"ShippedDate," & _
"Freight" & _
"From [Orders]"
End Sub
</script >
' Alternate sql-25 Records
Application ("SQL") = "SELECT Top OrderID," & _
"CustomerID," & _