tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Steve Ruby <>
Subject Re: Speeding up database accesses
Date Mon, 05 Feb 2001 21:42:21 GMT

For one reason you are going to have a connection dedicated
to that session even if it isn't using it, so you will
have one connection per session when you really only need
one connection per use which is likely to be MUCH smaller, especially
considering the session doesn't die until session-timeout so you
will have a buch of lame connection sitting around takeing up
memory waiting to die..

A pool (especially a good one) will allow you to have
only the number of connections you need available to you
at any time.

CPC Livelink Admin wrote:
> Why is it a bad idea to use a session variable?
> -----Original Message-----
> From: Randy Layman []
> Sent: Monday, February 05, 2001 3:52 PM
> To:
> Subject: RE: Speeding up database accesses
>         One possibility (altough a bad idea) is to stick it into your
> session.
>         Another possibility is to create an object that has a static
> variable for the Connection.  Then provide methods to access it.  Remember
> that you need to make sure only one thing at a time is using the connection.
>         There are some pooling connection managers out there already.  One
> that I know of off the top of my head is PoolMan.  You can go over to
> and search for it.
>         Randy
> -----Original Message-----
> From: John Coonrod []
> Sent: Monday, February 05, 2001 4:19 PM
> To:
> Subject: Speeding up database accesses

View raw message