<snip> > connection pooling in the servers environment so I'm using a new connection > for each DB call I should think that's the most expensive bit : setting up a connection each time.
> connection for each session and check to see if its still valid each time it > is needed? There are many lookup lists It may be a better idea to set up a pool of physical connnections. A servlet should request a free one and when not in use anymore, drop it so that it is recycled for next servlet. Hope that helps. -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
