update更新数据库时,CPU占用100%..........
Equn 2004-12-17 11:56:06 更新语句如下:
dim msg
set rs=server.createobject("adodb.recordset")
rs.open "select * from bbs where id="&request("id"),conn,1,3
'rs.open "select * from bbs where id="&request("id"),conn,2,3,上面那句改成这样就不会了.
rs("websay")=request.Form("websay")
rs("web_say_time")=now
rs.update
set rs=nothing
if len(msg)=0 then
msg="回复留言完成"
else
msg="回复留言完成,"&msg
end if
call on_ok(msg,"?")
数据库如下:
CREATE TABLE [bbs] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[user_name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[user_email] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[phone] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[text] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[sendmail] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[face] [smallint] NULL ,
[xq] [smallint] NULL ,
[user_say_time] [smalldatetime] NULL CONSTRAINT [DF_bbs_user_say_time] DEFAULT (getdate()),
[websay] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[web_say_time] [smalldatetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
recordset对象打开时CursorType设为1就会出现CPU占用100%,设为2就不会了,为什么不呢? 不解。
环境:win2000(sp4)+iis 5.0+sql server 2000(sp3)