UC知道sqlserver查询速度慢
来源：百度知道 编辑：UC知道 时间：2024/05/22 18:12:29
如题
核心代码如下
<%
Dim ClassID,NClassID,ParentID,strClass,strNClass,strTemp,n
SQL="SELECT "&stbc&".ID,"&stbc&".title as bcname,"&stbc&".mode as bcmode,"&stbc&".[view] as bcview,"&stbc&".Orders,"&stbc&".Orders AS bcorder,"&stsc&".ID AS scid,"&stsc&".title as scname,"&stsc&".mode as scmode,"&stsc&".pcid,"&stsc&".[view] as scview,"&stsc&".Orders AS scorder FROM "&stbc&" LEFT JOIN "&stsc&" ON "&stsc&".pcid="&stbc&".ID ORDER BY "&stbc&".Orders,"&stsc&".Orders"
Set Rs=Conn.Execute(SQL)
If Rs.Eof Or Rs.Bof Then
Response.Write ("<tr><td colspan='2' align='left'> 尚未添加分类</td></tr>")
Else
strTemp=""
Do While Not Rs.EOF
tbcid=Rs("id")
核心代码如下
<%
Dim ClassID,NClassID,ParentID,strClass,strNClass,strTemp,n
SQL="SELECT "&stbc&".ID,"&stbc&".title as bcname,"&stbc&".mode as bcmode,"&stbc&".[view] as bcview,"&stbc&".Orders,"&stbc&".Orders AS bcorder,"&stsc&".ID AS scid,"&stsc&".title as scname,"&stsc&".mode as scmode,"&stsc&".pcid,"&stsc&".[view] as scview,"&stsc&".Orders AS scorder FROM "&stbc&" LEFT JOIN "&stsc&" ON "&stsc&".pcid="&stbc&".ID ORDER BY "&stbc&".Orders,"&stsc&".Orders"
Set Rs=Conn.Execute(SQL)
If Rs.Eof Or Rs.Bof Then
Response.Write ("<tr><td colspan='2' align='left'> 尚未添加分类</td></tr>")
Else
strTemp=""
Do While Not Rs.EOF
tbcid=Rs("id")
清理一下，sql服务器吧。
可以换个方式重写这些代码。这样循环相信你也快不到哪去。
另外，把你的SQL语句response出来，放到分析器执行一下，看一下时间。
If Rs.Eof and Rs.Bof Then
Do While Not Rs.EOF这个也不用了，不是和前面判断重复了。
看着眼晕
感觉问题在循环上
表与表关联着的字段加索引吧，这样立竿见影。