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.