超时过期错误 [英] TimeOut Expired Error

问题描述

嗨
我正在使用sql express 2008 R2.我的数据库大小为3.89 GB，我已经对其进行升级以支持直到10 GB的大小.

现在我正在尝试为表选择查询

成功执行

但是当我尝试插入查询

它给了我异常

超时时间已到.操作完成之前已过超时时间，或者服务器没有响应


我没有得到什么问题.

请帮助我

在此先感谢

Hi
I am using sql express 2008 R2.My Database size is 3.89 GB and i have upgrade it to support till 10 GB size.

Now I am trying select query for Table

It''s Execute sucessfully

But when I try to insert query

Its Gives Me Exception

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding


I am not getting what is issue.

Please Help Me

Thanks In Advance

推荐答案

因此，您正在尝试访问具有大量数据的数据库.因此查询执行时间将更多.如果您详细研究了ADO.NET，则这主要取决于两件事.

第一个是数据库连接的连接超时.基本上是经过时间才能解决连接问题. ConnectionTimeOut属性将解决该问题.

第二个是数据访问或读取的超时. Command对象的CommandTimeOut属性将解决此问题.

请检查每个属性名称的拼写.我不记得它们的确切拼写.

So you are trying to access a database which is having large volume of data. So the query execution time will be more. If you have looked at ADO.NET in details this mainly depends on two things.

First one is the connection timeout for database connection. Basically time elapse to resolve the connection. ConnectionTimeOut property will solve that issue.

The second one is the timeout for data access, or read. CommandTimeOut property of the Command object will resolve the issue.

Please check spelling for each property names. I cannot remember the exact spelling on them.

这篇关于超时过期错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！