Developer forum

Forum » CMS - Standard features » SQL Connection timeout

SQL Connection timeout

Terri Donahue Dynamicweb Employee
Terri Donahue
Reply

Hi guys,

I need to increase the default sql connection timeout from 10 seconds to 30 seconds. I don't see a way to configure this in the globlsettings.aspx file. Is there a way to do this?


Replies

 
Nicolai Pedersen Dynamicweb Employee
Nicolai Pedersen
Reply

That is not possible. 

You can use the connection string setting and construct the entire connectionstring (inlcuding username and password) to override the connection timeout (Connection Timeout=30).

You can change the command timeout using /GlobalSettings/System/Database/CommandTimeout - default is 30.

BR nicolai

 
Terri Donahue Dynamicweb Employee
Terri Donahue
Reply

Thanks Nicolai,

I took a memory dump and analyzed it this morning. Our client is running Dw 9.8.11 and there isn't anything that I am aware of that is setting the connection timeout, but it is definitely set to 10 seconds. I'll test in their dev environment updating the globalsettings file to see if I can override that value.

ADO.NET Connections Report

Connection Type MaxPoolSize Connection String Current Connection Count Connections Open
System.Data.SqlClient.SqlConnectionString 200 User Id=dbuser;Password=*****;Initial Catalog=databasename;Server=.;Min Pool Size = 5; Max Pool Size=200; 43 43
System.Data.SqlClient.SqlConnectionString 200 Server=.;Database=biolegend.com;User Id=dbuser;Password=*****;Min Pool Size = 1; Max Pool Size=200;Connection Timeout=10; 1 1
 
Nicolai Pedersen Dynamicweb Employee
Nicolai Pedersen
Reply

It could be a custom ConnectionProvider which is a piece of code you can add to Dynamicweb.

 

You must be logged in to post in the forum