Benchmarks - Results

The tests used in the benchmarks and the subsequent results are summarised below:

Test ASP page

A single simple ASP page was used. This page made a single SQL request to the Northwind sample database.

Select CustomerID, CompanyName, ContactName, ContactTitle, Address, City, Phone from customers

And printed out the results. Two tests were made.

Test 1

10 minute test using native OLE DB provider for SQL 2000 Server

Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open "Provider=SQLOLEDB;Data Source=myserver;User Id=sa;Password=;Initial Catalog=Northwind"

Summary results are as follows. (the full results)

Number of hits: 19993
Requests per Second: 33.33
Average number of SQL connections 52

Test 2

10 Minute Test using native OLE DB provider and SQLCache

Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open "Provider=SQLCache.Cache;Original Provider=SQLOLEDB;User Id=sa;Password=;Data Source=SQLServername;Initial Catalog=Northwind"

Summary results are as follows. (the full results)

Number of hits: 28495
Requests per Second: 47.50
Average number of SQL connections 1