Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database configuration » Database options » Alphabetical list of database options

http_connection_pool_basesize option

Specifies the nominal threshold size of database connections.

Allowed values

Integer, between 0 and 1000, inclusive

Default

10

Scope
  PUBLIC role For current user For other users
Allowed to set permanently? Yes, with SET ANY SYSTEM OPTION No No
Allowed to set temporarily? Yes, with SET ANY SYSTEM OPTION No No
Remarks

Changing this option takes effect within 5 seconds during the next purge cycle. Any unused database connections having exceeded http_connection_pool_timeout within the http_connection_pool_basesize threshold are deleted. When the size of a connection pool exceeds the http_connection_pool_basesize threshold, connections are deleted at a more aggressive rate.

Specifying a value of 0 purges the HTTP connection pools within 5 seconds of setting the option and disables HTTP connection pooling.

Unused excess connections are removed within half the timeout interval, half of the remainder are purged if unused within a quarter timeout interval, and so on. The following database properties have been added to determine the operating efficiency of the connection pools within a database:

  • HttpConnPoolCachedCount
  • HttpConnPoolHits
  • HttpConnPoolMisses
  • HttpConnPoolSteals