Caldarale, Charles R wrote:
This really sounds like you're not using connection pooling, but instead
are opening a new connection for each request. How many do you have
configured in the pool? If it's less than the number you see with
netstat, that would be another indication that your app is getting its
own connections rather than ones from the pool.
Is your app closing the connections (and statements and result sets)
properly? This usualy requires putting the close statements in finally
blocks, just to make sure that exceptions don't cause them to be
skipped.
Additionally, you speak of multiple connections because you need to hit
multiple tables.
There are cases where such is all but necessary, but enough
sophistication with unions, joins, etc, can reduce the number of round
trips you make to the database, which can be quite important given any
communication latency.
--
Jess Holle
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]