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:
|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|