in asp.net c# project and sql server 2008r2 and ado.net i was added and increase maxpoolsize attribute in connection string and my time out issue hass been fixed but i read this MSDN article completely but there is no reference about side effect for increasing.
在asp.net c#项目和sql server 2008r2和ado.net中，添加并增加了连接字符串中的maxpoolsize属性，修复了我的超时问题hass，但我完全阅读了这篇MSDN文章，但是没有提到增加的副作用。
for compare these situation increase and decrease max pool size i was testing my query with this stored procedure from sql server .
为了比较这些情况的增加和减少最大池大小，我使用sql server中的这个存储过程测试查询。
1 个解决方案
#1
0
if there is open and usable connection, connection pool provides that you can use them again. So it increases the performance.
如果有打开的和可用的连接，连接池提供您可以再次使用它们。它提高了性能。
Use Sql Stored procedure for database process. It is the best way for performance and security! But Don't forget to close the connection =)
使用Sql存储过程进行数据库处理。这是性能和安全性的最佳方式!但是不要忘记关闭连接=)
#1
0
if there is open and usable connection, connection pool provides that you can use them again. So it increases the performance.
如果有打开的和可用的连接，连接池提供您可以再次使用它们。它提高了性能。
Use Sql Stored procedure for database process. It is the best way for performance and security! But Don't forget to close the connection =)
使用Sql存储过程进行数据库处理。这是性能和安全性的最佳方式!但是不要忘记关闭连接=)