Database initialization
This section contains the tests and environment variables
used during database initialization.
Work queue
The work queue consists of a single queue instance and
a configurable number of worker threads that run work placed on it.
Connection pool
The Warehouse Proxy uses several pre-initialized ODBC connections
to access the target database. The use of these ODBC connection objects
is synchronized through a single connection pool. The connection pool
is initialized when the Warehouse Proxy starts.
RPC threads and export requests
In addition to the configurable environment variables discussed
previously, the standard agent framework provides some control over
the scalability and performance profile for the Warehouse Proxy.
Timeout values
You can set two environment variables to control the timeout
value. One variable is set on the application agent, the other on
the Warehouse Proxy.