水兰花有毒吗:有段asp连接sql数据库的程序，可是连接非常慢，请高手看看怎么回事？

<%set rs=server.createobject("adodb.recordset")
rs.open "select * from SMT_sca where SMT_key=1 and SMT_key1=1 and SMT_key2=1",conn,1,1
scacount=rs.recordcount
rs.close
rs.open "select * from SMT_cp where SMT_key=1 and SMT_key1=1 and SMT_key2=1",conn,1,1
cpcount=rs.recordcount
rs.close
rs.open "select * from SMT_job_zp where SMT_key=1 and SMT_key1=1 and SMT_key2=1",conn,1,1
zpcount=rs.recordcount
rs.close
rs.open "select * from SMT_job_qz where SMT_key=1 and SMT_key1=1 and SMT_key2=1 and SMT_iname is not null",conn,1,1
qzcount=rs.recordcount
rs.close
rs.open "select * from SMT_yp where SMT_key<>0 and SMT_key<>2 and SMT_key1=1",conn,1,1
ypcount=rs.recordcount
rs.close
rs.open "select * from SMT_exhibit where SMT_key<>0 and SMT_key2=1",conn,1,1
zhcount=rs.recordcount
rs.close
rs.open "select * from SMT_xxnews where SMT_key=1 and SMT_key1=1 and SMT_key2=1",conn,1,1
newscount=rs.recordcount
rs.close
rs.open "select * from SMT_news where SMT_key=1 and SMT_key1=1 and SMT_key2=1",conn,1,1
newscount=rs.recordcount+newscount
rs.close
set rs=nothing%>