UC知道如何快速地批量删除数据?我的程序很慢
来源：百度知道 编辑：UC知道 时间：2024/06/18 22:41:22
我的程序如下,执行时间约35秒,运行时CPU100%,如何写程序能较快删除,谢谢啦
<!--#include file="conn.asp"-->
<%set rs=Server.CreateObject("adodb.recordset")
sql="select top 1000 id from [mess] order by id asc"
rs.open sql,conn,3,3
I=0
if not rs.eof then
do while not rs.eof
rs.delete
I=I+1
rs.movenext
loop
end if
rs.close
set rs=nothing
response.write "成功删除"&I&"条记录！"
%>
<!--#include file="conn.asp"-->
<%set rs=Server.CreateObject("adodb.recordset")
sql="select top 1000 id from [mess] order by id asc"
rs.open sql,conn,3,3
I=0
if not rs.eof then
do while not rs.eof
rs.delete
I=I+1
rs.movenext
loop
end if
rs.close
set rs=nothing
response.write "成功删除"&I&"条记录！"
%>
一句话解决问题！
conn.execute("delete from (select top 1000 id from [mess] order by id asc)")
response.write "成功删除记录！"
delete @#
用这个自己改下把
<% contentID=request("ID")
set rs=server.createobject("adodb.recordset")
sqltext="delete from newtitle where Id="& contentID
rs.open sqltext,conn,3,3
set rs=nothing
conn.close
response.redirect "Manage_newdongtai.asp"
%>