You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
In NETProvider\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbConnectionPoolManager.cs , Pool.CleanupPool() does the following:
var keep = available.Where(x => x.Created.AddSeconds(_connectionString.ConnectionLifeTime) > now).ToArray();
This does not take into account the default(!) value of zero for _connectionString.ConnectionLifeTime.
The effect is that connections are closed and recreated for every request.
You can see TCP-connections closing and new ones reopening by using TcpView by SysInternals.
I think that depends on the situation, the context in which the connections are made and how much the connection will be used. Someone could want a lifetime of 10 seconds, but others 60 seconds or maybe longer, like infinite.
I'd say, don't change it and leave it to zero (i.e. infinite).
Submitted by: Erik Jan Meijer (eegee)
In NETProvider\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbConnectionPoolManager.cs , Pool.CleanupPool() does the following:
var keep = available.Where(x => x.Created.AddSeconds(_connectionString.ConnectionLifeTime) > now).ToArray();
This does not take into account the default(!) value of zero for _connectionString.ConnectionLifeTime.
The effect is that connections are closed and recreated for every request.
You can see TCP-connections closing and new ones reopening by using TcpView by SysInternals.
Commits: 62e1df8 e5b1556
The text was updated successfully, but these errors were encountered: