Provides configuration of the global database connection pool. Because the database connection pool is global, only a single instance of the DatabaseConnectionPool class may be created. The global database connection pool allows you to reuse network connections across multiple Database objects. Calling Database.Connect() is a relatively expensive operation, especially in applications that create a potentially large number of Database objects. The database connection pool optimizes this by caching network connections and reusing them in subsequent Database.Connect() calls. When a Database object is disposed, the connection is automatically returned to the database connection pool. Connection pooling operates transparently, but only applies for Database objects for which the Id, WorkgroupServerName and TrustedUser properties have been set. Note that all three of these properties must be set, for connection pooling to be enabled. The DatabaseConnectionPool class implements the IDisposable interface. DatabaseConnectionPool objects must be properly disposed by your program, either by calling Dispose () in a 'finally' clause, or with a 'using' clause.
More...
Provides configuration of the global database connection pool. Because the database connection pool is global, only a single instance of the DatabaseConnectionPool class may be created.
The global database connection pool allows you to reuse network connections across multiple Database objects. Calling Database.Connect() is a relatively expensive operation, especially in applications that create a potentially large number of Database objects. The database connection pool optimizes this by caching network connections and reusing them in subsequent Database.Connect() calls. When a Database object is disposed, the connection is automatically returned to the database connection pool.
Connection pooling operates transparently, but only applies for Database objects for which the Id, WorkgroupServerName and TrustedUser properties have been set. Note that all three of these properties must be set, for connection pooling to be enabled.
The DatabaseConnectionPool class implements the IDisposable interface. DatabaseConnectionPool objects must be properly disposed by your program, either by calling Dispose () in a 'finally' clause, or with a 'using' clause.