database.maxIdle

This property indicates the maximum number of connections to the Spotfire® Statistics Services that can remain idle in the pool without extra connections being destroyed.

Property Name Default Value Property Description
database.maxIdle 1 The maximum number of connections that can remain idle in the pool, without extra ones being destroyed.

If database.maxIdle is set too low on heavily-loaded systems, you might see connections being closed and new connections opened almost immediately. This is a result of the active threads momentarily closing connections faster than connections are opened, causing the number of idle connections to rise above database.maxIdle. For heavily-loaded systems, the best value for database.maxIdle can vary, but the default is a good starting point.

The default is 1. You can set to a negative value to specify no limit.