...
For more information about how to use these properties to tune the performance of the Aggregation agent, see Aggregation Agent in the Desktop User's Guide(4.1).
EC Web Interface Properties
...
Property | Description |
|---|---|
max.cached.prepared.statements | Default value: If you want to change the number of preparedStatements that are cached between connections, you can use this property to specify a different number than the default. If you are using SAP HANA as a database type in a Database profile, used by Database agents, this value has to be set to 0. |
connectionpool.strict.pool.size | Default value: If you enable this property, the database pool enables the Blocking Queue implementation where there is a strict restriction to the maximum number of connections. When the property is set to false, then the database connection pool will create additional temporary connections. When the pool is full, these connections are closed as soon as the workflow thread returns the connection to the pool. This property is general for all supported databases. It is enabled per each EC separately. If enabled the connection pool for the particular EC have a strict maximum limit. The maximum limit can be set in the Database profile agents Properties tab. For more information on this tab, refer to the Database Profile(4.1). |
connectionpool.wait.timeout.milliseconds | Default value: This property can only be used if the connectionpool.strict.pool.size property is set to This property is used to configure the amount of time a thread should remain in the blocked queue until it tries for a new connection. If a connection is made available before this time, the thread's waiting time is interrupted. |
...