Optimising Dbvisit Standby

Owned by KrupeshD (Deactivated)
Last updated: Jun 26, 2012
1 min read

By default Dbvisit Standby initiates a database connection each time information is requested from the database. The connection is closed after each request. This is called the dedicated database connection mode.

For databases where the time to initiate each connection takes too long, it is possible to optimise Dbvisit Standby by opening only one database connection and using this connection for the duration of the Dbvisit Standby processing.

This is called the shared database connection mode and can be set by editing the DDC file and setting:

DB_CONNECTION_MODE=shared
DB_CONNECTION_MODE_DR=shared

Dbvisit Standby will only initiate the database connection once. If the database connection is lost or closed during Dbvisit Standby processing for any reasons, Dbvisit Standby will re-initialise the database connection.