<%
....
sql="select products_id......"

set srs=conn.execute(sql)
用以上语句效率比较低下,改用以下语句

srs.activeconnection = conn
srs.cursortype = 1 adopenkeyset
srs.locktype = 1 adlockreadonly
srs.open sql
....
%>