[讨论]查询速度太慢

芯頽廢.。﹖

各位老师:
以下是完整查询语句,但是查询2000条信息都要1分多钟,请问各位老师,怎么改速度才快些呀!

<td colspan="8" nowrap><div align="left">
<%
set rs=server.CreateObject("adodb.recordset")
if request("DATA")="" and request("DATA1")="" then
sql="select sum(BANKNOTE) as BANKNOTE1,sum(LETTER) as LETTER1, sum(WEIGHT) as WEIGHT1 FROM ESDISPATCH "
ELSE
sql="select sum(BANKNOTE) as BANKNOTE1,sum(LETTER) as LETTER1, sum(WEIGHT) as WEIGHT1 FROM ESDISPATCH WHERE DATA between #"&cdate(request("DATA"))&"# and #"&cdate(request("DATA1"))&"# "
END IF
rs.open sql,conn,1,1
%>结果统计：票数【<font color='blue'><%=rs("BANKNOTE1")%></font>】票&nbsp;件数【<font color='blue'><%=rs("LETTER1")%></font>】件&nbsp;重量【<font color='blue'><%=rs("WEIGHT1")%></font>】KG
</div></td>

Secret

我刚看,所以才有此想法
但是不知道怎么改!
能提提意见吗?谢谢!

专属天使

http://bbs.bc-cn.net/viewthread.php?tid=156547

建议看看上面的帖子！