从Web应用程序执行存储过程时发生超时错误 [英] timeout error while executing a stored procedure from a web applicaiton

问题描述

从查询分析器运行存储过程与从Web应用程序运行存储过程之间有什么区别???

解决方案

您可能需要增加SQLCommand对象的超时，如果您的应用程序在执行存储过程时超时.

如果尝试去获取/获取连接对象时超时，则可能必须增加SQLConnection对象的超时.

存储过程超时的另一种选择是通过索引相关数据库列来优化存储过程的性能

what is the difference between running a stored procedure from a query analyzer and running a stored procedure from a web application???

解决方案

You may have to increase the timeout of the SQLCommand object, if your application is timingout while executing the stored procedure.

you may have to increase the timeout of the SQLConnection object, if you are getting time out while trying go get retrive/get a connection object.

the other option for the stored procedure timeout is to optimise the stored procedure for the performance by indexing the relevent database columns

这篇关于从Web应用程序执行存储过程时发生超时错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！