IEC utilizes a pool for its database connections. The database connections are used both for updating messages' metadata and for logging. If either of these consumers increase significantly then the number of database connections should also be increased, or you will create a bottleneck. It's not desirable to increase the number of database connections infinitely. Database connections are a limited resource and it will have an impact on the database server and possibly on other applications using 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|