SQL Connection Pool Settings

See Also

• Server Info

Allows you to configure connection pool settings. Connection pool provides an efficient way of maintaining SourceAnywhere database connections, thereby enhancing the performance of executing commands on the database.

Note: Changes in this window call for restarting the SourceAnywhere Service to take effect.

Window Items

SQL Connection Pool

• Minimum Connections - Specifies the minimum number of connections to maintain. Connections will not be discarded if this number is not reached. However, the connection pool does not create connections solely to ensure that the minimum connection pool size is maintained.
  Default value: 5
   
• Maximum Connections - Specifies the maximum number of connections that can be created. Once this number is reached, no new  connections are created and the requester waits for an in-use connection to times out and returns to the pool. The value of Maximum Connections must be no less than that of Minimum Connections.
  Default value: 20
   
• Connection time out - Specifies an interval, in seconds, after which a connection request times out. 0 (Zero) indicates unlimited.
  Default value: 60
   
• Life time - Specifies an interval, in seconds, after which an unused or idle connection is discarded.
  Default value: 0 (Zero indicates unlimited.)