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]