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文件）包，方便喜欢折腾的同学，附件如下：