DB pool settings

IEC uses a pool for its database connections. The database connections are used both for updating the metadata of messages and for logging. If either of these consumers increases significantly, then the number of database connections should also be increased, to avoid bottleneck. The number of database connections should not be increased infinitely. Database connections are a limited resource and it will have an impact on the database server and possibly on other applications that use the same database server.

Implement these installation settings for DB pool:

Recommended settings Definition
Database.ConnectionPoolExt.MinIdle = Increase if messages arrive in bursts
Database.ConnectionPoolExt.InitialSize = Increase if messages arrive in bursts
Database.ConnectionPoolExt.MaxIdle = + Same percentage that the threads were increased with
Database.ConnectionPoolExt.MaxActive = + Same percentage that the threads were increased with