比较方法,哪个更快?
oubao 2004-11-24 02:36:30 第一种方法
for i=1 to 10
Set rs = Server.CreateObject("Adodb.RecordSet")
sqlv = " SELECT * FROM TSARTNChkDtl "
rs.open sqlv, conn, 1, 3
rs.AddNew
rs("cditchid") = cditchid
rs("csaretchkid") = pay_id_all
rs("csaretchkdtlid") = no1
rs.update
rs.close
next
第二种方法
for i=1 to 10
sql = "insert TSARTNChkDtl (cditchid,csaretchkid,csaretchkdtlid) values ('"&CDITCHID&"','"&pay_id_all&"','"&no1&"')"
end if
conn.execute sql
next
哪种方法速度更快些?效率好些?