Connection Pool Mode in SAP BusinessObjects Universe

[kumar_kesireddy]

There are many blogs on discussing this topic but I would like to share the one SAP has in its documentation.

I think instead of calling it a Connection Pool Mode, its better to say Connection Modes

The three types of Connection Modes are

Disconnect after each transaction

Keep the connection active for (This option is the Pooling one. Like a car pool)

Keep the connection active during the whole session

Disconnect after each transaction: Disconnects from the database after a query is completed. The next time a query is run, the connection is re-created.

- Pool Timeout is greyed out

Keep the connection active for: This is the connection pooling option. If a query is completed before the time specified in Pool Timeout (10 minutes is the default), then the connection can be re-used. All the users share the connection.

Keep the connection active during the whole session (local mode only): The connection is closed when the user exits the application. This option does not use the connection pooling.

- Pool Timeout is greyed out

Choosing the Connection Pool Mode:

The connection pool mode may depend on the availability of your machine resources.

● If the memory is low, then choose the Disconnect after each transaction option.

● If the memory is high and the performance is critical, then choose the Keep the connection active during the whole session (local mode only) option.

● To control the behavior more precisely, choose the Keep the connection active for option.

MK!