sql语句执行效率问题?
Set cmdTemp = Server.CreateObject("ADODB.Command")
set rs1 = server.CreateObject ("adodb.recordset")
sql="select id,comid,companyName,zuijiaguzhu from [ijob_company] where comid='"&rs("comid")&"'"
cmdTemp.CommandText = sql
cmdTemp.CommandType = 1
Set cmdTemp.ActiveConnection = conn
rs1.Open cmdTemp, , 1, 1
和
set rs1 = server.CreateObject ("adodb.recordset")
sql="select id,comid,companyName,zuijiaguzhu from [ijob_company] where comid='"&rs("comid")&"'"
rs1.Open sql,conn 1, 1
哪个执行起来效率更高。有什么区别?