Yes, we do joins where appropriate and I guess I
should clarify the inaccuracy of my initial statement
- there is one connection per request (for each
individual sql), rather then for each unique table.

-marc

--- Jess Holle <[EMAIL PROTECTED]> wrote:

> 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]
> 
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to