ASP 中调用set rs=server.createobject("adodb.recordset") rs.open sql,conn,1,1时可以有如下两种方式：

    1.创建一个销毁一个 
    2.页面开始创建一个,中间直接调用,网页最后再销毁
以下为两种方式的执行效率比较：
a.asp代码如下：
<%
stame = timer()

set conn = server.createobject("ADODB.Connection")
conn.open "provider=microsoft.jet.oledb.4.0;data source=" & server.mappath("db1.mdb")

sub test
  set rs = server.createobject("ADODB.Recordset")
  rs.open "select * from news",conn,1,1
  tt = rs(0)
  rs.close
  set rs = nothing
end sub

for i = 1 to 10000
  test
next
response.write (timer()-stame) * 1000 & "毫秒."
%>
 
c.asp代码如下：
<%
stame = timer()

set conn = server.createobject("ADODB.Connection")
conn.open "provider=microsoft.jet.oledb.4.0;data source=" & server.mappath("db1.mdb")
set rs = server.createobject("ADODB.Recordset")

sub test
  rs.open "select * from news",conn,1,1
  tt = rs(0)
  rs.close
end sub

for i = 1 to 10000
  test
next
set rs = nothing
response.write (timer()-stame) * 1000 & "毫秒."
%>
 
最后符上代码（含db文件）包，方便喜欢折腾的同学，附件如下：