access换成sqlserver后,变得很慢
<%
set rs1=server.CreateObject("adodb.recordset") '社区户主
sql1="select * from people where dq='"&session("dq")&"' and name<>'' order by id desc"
rs1.open sql1,conn,1,1
while not rs1.eof and not rs1.bof
i=i+1
rs1.movenext
wend
rs1.close
set rs1=nothing
i1=i1-rhzk1-rhzk2
response.Write(i)
%>
access数据库超过100M的,换成了sqlserver,结果速度感觉更慢了,
people表中有40000多条数据,我用while逐条读取结果就脚本超时了,想问一下有什么办法解决