| 今天做了个测试，10W条数据，测试结果记录如下：
startime = timer()
set rs = Server.CreateObject("adodb.recordset")
rs.Open "select * from test",conn,1,1
do while not rs.EOF
Response.Write(rs(0) & " ")
rs.MoveNext
loop
rs.Close
set rs = nothing
endtime = timer()
Response.Write("<br />" & FormatNumber((endtime-startime)*1000,3))
执行时间：156.250毫秒
===========================================================================
startime = timer()
set rs = conn.Execute("select * from test",1,1)
do while not rs.EOF
Response.Write(rs(0) & " ")
rs.MoveNext
loop
endtime = timer()
Response.Write("<br />" & FormatNumber((endtime-startime)*1000,3))
执行时间：125.000毫秒
===========================================================================
startime = timer()
set rs = Server.CreateObject("adodb.recordset")
rs.Open "select * from test",conn,1,1
rsCount = rs.RecordCount
for i = 1 to rsCount
Response.Write(rs(0) & " ")
rs.MoveNext
next
rs.Close
set rs = nothing
endtime = timer()
Response.Write("<br />" & FormatNumber((endtime-startime)*1000,3))
执行时间：140.625毫秒
===========================================================================
startime = timer()
rsCount = conn.Execute ("select count(id) from test",0,1)(0)
set rs = conn.Execute("select * from test")
for i = 1 to rsCount
Response.Write(rs(0) & " ")
rs.MoveNext
next
endtime = timer()
Response.Write("<br />" & FormatNumber((endtime-startime)*1000,3))
执行时间：109.375毫秒 | 
