|
With most databases, there is a significant performance overhead
incurred when opening and closing database connections. For this
reason, most modern application servers implement the idea of connection
pooling. They maintain a pool of available database connections
that are shared among all the incoming web server requests. When
the web server receives a new request for a page, the application
server uses an existing connection from the pool (if one is available),
processes the request, and then returns the connection to the pool.
If no connection is available, the requesting thread waits until
one becomes available. The zeroCode-generated application includes
such a connection-pooling facility, thus enhancing the throughput
and reliability of your site .
The database Connection
Pool Management is now highly configurable.
It allows you to decide how scalable you want your connection pool
to be. You get to decide the following:
- The Pool size - the number of connections you want ·
- The number of times a thread should retry if it fails to get
a connection
- The interval between retries
These parameters are specified in the config file
|