OLAP pooled connections

The OLAP connection pool stores opened OLAP connections.

There are pooled and non-pooled OLAP connections. OLAP pooled connections do not disconnect from OLAP when released. The connections are opened by the Application Engine Service for a few minutes in case they are needed again.

Pooled connections can save time that would be spent for connecting and disconnecting from OLAP. They are useful for processes that must open and close connections often but which cannot pass those connections across the process.

If a required connection is found in the pool, it is used instead of creating a new OLAP connection.

There are differences between functions responsible for releasing and disconnecting a pooled connection:

  • OLAPReleasePooledConnection: Puts the connection to a pool and does not disconnect it. It should be used for all normal cases where a pooled connection was used.
  • OLAPDisconnectPooledConnection: Disconnects the connection instead of pooling it. It is used for special cases when you know that you no longer need the connections.
  • OLAPDisconnectAllPooledConnections: Disconnects all currently open pooled connections. It is used for special cases when you know that you no longer need it the connections.