ALTER EXTERNAL CONNECTIONS POOL

`ALTER EXTERNAL CONNECTIONS POOL`

Manages the external connections pool

Syntax

ALTER EXTERNAL CONNECTIONS POOL
  { CLEAR ALL
  | CLEAR OLDEST
  | SET LIFETIME lifetime <time-unit>
  | SET SIZE size }

<time-unit> ::= SECOND | MINUTE | HOUR

Table 1. `ALTER EXTERNAL CONNECTIONS POOL` Statement Parameters
Parameter	Description
lifetime	Maximum lifetime of a connection in the pool.Minimum values is `1 SECOND`, maximum is `24 HOUR`.
size	Maximum size of the connection pool.Range 0 - 1000.Setting to `0` disables the external connections pool.

When prepared it is described like a DDL statement, but its effect is immediate — it is executed immediately and to completion, without waiting for transaction commit.

This statement can be issued from any connection, and changes are applied to the in-memory instance of the pool in the current Firebird process.If the process is Firebird Classic, execution only affects the current process (current connection), and does not affect other Classic processes.

Changes made with ALTER EXTERNAL CONNECTIONS POOL are not persistent: after a restart, Firebird will use the pool settings configured in firebird.conf by ExtConnPoolSize and ExtConnPoolLifeTime.

Clauses of `ALTER EXTERNAL CONNECTIONS POOL`

CLEAR ALL: Closes all idle connections and disassociates currently active connections;they are immediately closed when unused.
CLEAR OLDEST: Closes expired connections
SET LIFETIME: Configures the maximum lifetime of an idle connection in the pool.The default value (in seconds) is set using the parameter ExtConnPoolLifetime in firebird.conf.
SET SIZE: Configures the maximum number of idle connections in the pool.The default value is set using the parameter ExtConnPoolSize in firebird.conf.

ALTER EXTERNAL CONNECTIONS POOL