服务器请求超时但查询在sql server上运行 [英] server request time out but query running at sql server

问题描述

我使用单个命令插入2500条记录，执行该操作需要8或10分钟



但是90秒后我的代码抛出请求超时错误在ScriptResource.axd



现在此查询仍然在sql server上运行，在8或9分钟之后它继续使用代码（意味着继续下一个cmd.ExcuteNonQuery的声明）



我如何确保我的用户等待8或9分钟仍然完成？



bcoz我已经创建了please wait并且此消息仍然保持请求超时错误抛出。

我如何在sql-server上运行该查询为请等待留言需要很长时间。



如果你没有得到我的问题或任何疑问，请发表必要的评论。

I am inserting around the 2500 record with the single command ,and it takes 8 or 10 minute to perform that

but after 90 second my code throw the "request time out error " in ScriptResource.axd

now this query still running at sql server and after 8 or 9 minute it's continue with the code(means continue with the next statement of cmd.ExcuteNonQuery)

How am i ensure my user to wait 8 or 9 minute still it finish?

bcoz i already created "please wait" and this message stay still request time out error is throw.
how i get that query is running at sql-server to make long time for "please wait" message.

if you don't get my question or any query, please make needful comments.

推荐答案

如何插入这些记录？您使用的查询是什么？



我建议您在查询中插入所有记录检查：



SQL - 服务器 - 三方法对插入 - 多行 - 进入 - 单表-SQL中-60秒-024视频/ [< a href =http://blog.sqlauthority.com/2012/08/29/sql-server-three-methods-to-insert-multiple-rows-into-single-table-sql-in-sixty-seconds- 024-video /target =_ blanktitle =New Window> ^ ]



希望它有所帮助。

How Do you insert those record ? what is the query that you use ?

I suggest that you insert all record in on query check this :

sql-server-three-methods-to-insert-multiple-rows-into-single-table-sql-in-sixty-seconds-024-video/[^]

Hope it will help.

我通过设置web-service对象的超时来解决这个问题。请帮助我。

i solved this by set timeout for web-service object. thk to help me.

这篇关于服务器请求超时但查询在sql server上运行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！