HttpWebRequest.Timeout Property Value The number of milliseconds to wait before the request times out......from msdn
请问HttpWebRequest.Timeout 在哪儿设置
System.Net.HttpWebRequest你的存储过程应该可以优化.用优化索引试试.
to ajex(仙桃人) 请问如何优化索引啊,对索引不是很懂 我每个表都有一个primarykey字段
sql企业管理器:工具---向导-----管理------索引优化向导
HttpWebRequest.Timeout Property Value The number of milliseconds to wait before the request times out......from msdnSystem.Net.HttpWebRequest.Timeout不行的呀,唉根本没法设呀,编译都有问题
超时问题我已经解决了,那是因为sqlcommand默认执行时间是30秒。我的存储过程已经优化了一下,但是执行速度还是不令人满意。麻烦哪位好心人,帮忙看看。CREATE Procedure BuildCheckStatTwo @CheckID varchar(16) --统计结果的存储过程 As Declare @CheckResultStatTwoID varchar(16) Declare @BeCheckedUserID varchar(16) Declare @CheckTableItemID varchar(16) Declare @CheckUserClassID varchar(16) Declare @CheckTableItemOptionID varchar(16) Declare @CheckTableItemOptionScore int Declare @ResultCount int Declare @TotalCount int Declare BeCheckedUser Cursor For Select BeCheckedUserID From PBeCheckedUserInfo Where CheckID=@CheckID Declare CheckTableItem Cursor For Select ItemID From PCheckTableItem Where TypeID In ( Select TypeID From PCheckTableType Where TitleID=( Select TitleID From PCheckIns Where CheckID=@CheckID ) ) Declare CheckUserClass Cursor For Select CheckUserClassID From PCheckUserClass Where CheckID=@CheckID --Delete From PcheckResultStatTwo Where CheckID=@CheckID Open BeCheckedUser Fetch Next From BeCheckedUser Into @BeCheckedUserID While @@Fetch_status=0 Begin Open CheckTableItem Fetch Next From CheckTableItem Into @CheckTableItemID While @@Fetch_status=0 Begin Declare CheckTableItemOption Cursor For Select LevelID,LevelScore From PCheckTableItemOption Where ItemID=@CheckTableItemID Open CheckTableItemOption Fetch Next From CheckTableItemOption Into @CheckTableItemOptionID,@CheckTableItemOptionScore While @@Fetch_status=0 Begin Open CheckUserClass Fetch Next From CheckUserClass Into @CheckUserClassID Select @TotalCount=0 While @@Fetch_status=0 Begin Select @ResultCount=Count(ItemScore) From V_PCheckResultTwo Where CheckID=@CheckID And BeCheckedUserID=@BeCheckedUserID And CheckUserClassID=@CheckUserClassID And ItemID=@CheckTableItemID And ItemScore=@CheckTableItemOptionScore --Exec GetPrimaryKey @CheckResultStatTwoID output insert into PCheckResultStatTwo (CheckID,BeCheckedUserID,CheckTableItemID,CheckUserClassID,CheckTableItemOptionID,ResultCount) values (@CheckID,@BeCheckedUserID,@CheckTableItemID,@CheckUserClassID,@CheckTableItemOptionID,@ResultCount) Select @TotalCount=@TotalCount+@ResultCount Fetch Next From CheckUserClass Into @CheckUserClassID End Close CheckUserClass insert into PCheckResultStatTwo (CheckID,BeCheckedUserID,CheckTableItemID,CheckUserClassID,CheckTableItemOptionID,ResultCount) values (@CheckID,@BeCheckedUserID,@CheckTableItemID,'0000000000000000',@CheckTableItemOptionID,@TotalCount) Fetch Next From CheckTableItemOption Into @CheckTableItemOptionID,@CheckTableItemOptionScore End Close CheckTableItemOption Deallocate CheckTableItemOption Fetch Next From CheckTableItem Into @CheckTableItemID End Close CheckTableItem Fetch Next From BeCheckedUser Into @BeCheckedUserID End Close BeCheckedUser Deallocate CheckUserClass Deallocate CheckTableItem Deallocate BeCheckedUserGO
server.timeout=4000应该是4000秒。鼠标移到上面提示以秒为单位。
我之所以都设为与4000相关是想看看加如是毫秒为计时单位得话,那超时时间应该是40秒才对。
现在得超时时间是30秒(秒表计时,绝对准确!),我找了很多地方,再也找不到30这个数字了:)
请问有没有什么默认超时时间为30秒的。
Property Value
The number of milliseconds to wait before the request times out......from msdn
在哪儿设置
请问如何优化索引啊,对索引不是很懂
我每个表都有一个primarykey字段
Property Value
The number of milliseconds to wait before the request times out......from msdnSystem.Net.HttpWebRequest.Timeout不行的呀,唉根本没法设呀,编译都有问题
a.Timeout=……
我用System.Net.HttpWebRequest a=new httpwebrequest();
a.Timeout=……提示需要什么Uri参数,老大,你有没有什么全点的代码啊,我很急!
a.Timeout=100000000;
As
Declare @CheckResultStatTwoID varchar(16)
Declare @BeCheckedUserID varchar(16)
Declare @CheckTableItemID varchar(16)
Declare @CheckUserClassID varchar(16)
Declare @CheckTableItemOptionID varchar(16)
Declare @CheckTableItemOptionScore int
Declare @ResultCount int
Declare @TotalCount int
Declare BeCheckedUser Cursor For Select BeCheckedUserID From PBeCheckedUserInfo Where CheckID=@CheckID
Declare CheckTableItem Cursor For Select ItemID From PCheckTableItem
Where TypeID In ( Select TypeID From PCheckTableType
Where TitleID=( Select TitleID From PCheckIns Where CheckID=@CheckID ) )
Declare CheckUserClass Cursor For Select CheckUserClassID From PCheckUserClass Where CheckID=@CheckID
--Delete From PcheckResultStatTwo Where CheckID=@CheckID
Open BeCheckedUser
Fetch Next From BeCheckedUser Into @BeCheckedUserID
While @@Fetch_status=0
Begin
Open CheckTableItem
Fetch Next From CheckTableItem Into @CheckTableItemID
While @@Fetch_status=0
Begin
Declare CheckTableItemOption Cursor For Select LevelID,LevelScore From PCheckTableItemOption Where ItemID=@CheckTableItemID
Open CheckTableItemOption
Fetch Next From CheckTableItemOption Into @CheckTableItemOptionID,@CheckTableItemOptionScore
While @@Fetch_status=0
Begin
Open CheckUserClass
Fetch Next From CheckUserClass Into @CheckUserClassID
Select @TotalCount=0
While @@Fetch_status=0
Begin
Select @ResultCount=Count(ItemScore) From V_PCheckResultTwo
Where CheckID=@CheckID And BeCheckedUserID=@BeCheckedUserID
And CheckUserClassID=@CheckUserClassID And ItemID=@CheckTableItemID And ItemScore=@CheckTableItemOptionScore
--Exec GetPrimaryKey @CheckResultStatTwoID output
insert into PCheckResultStatTwo (CheckID,BeCheckedUserID,CheckTableItemID,CheckUserClassID,CheckTableItemOptionID,ResultCount) values
(@CheckID,@BeCheckedUserID,@CheckTableItemID,@CheckUserClassID,@CheckTableItemOptionID,@ResultCount)
Select @TotalCount=@TotalCount+@ResultCount
Fetch Next From CheckUserClass Into @CheckUserClassID
End
Close CheckUserClass
insert into PCheckResultStatTwo (CheckID,BeCheckedUserID,CheckTableItemID,CheckUserClassID,CheckTableItemOptionID,ResultCount) values
(@CheckID,@BeCheckedUserID,@CheckTableItemID,'0000000000000000',@CheckTableItemOptionID,@TotalCount)
Fetch Next From CheckTableItemOption Into @CheckTableItemOptionID,@CheckTableItemOptionScore
End
Close CheckTableItemOption
Deallocate CheckTableItemOption
Fetch Next From CheckTableItem Into @CheckTableItemID
End
Close CheckTableItem
Fetch Next From BeCheckedUser Into @BeCheckedUserID
End
Close BeCheckedUser
Deallocate CheckUserClass
Deallocate CheckTableItem
Deallocate BeCheckedUserGO