On 08-Jun-2000 Jarec Basham wrote:
> Hi all,
>
> I've just inherited a servlet based system that makes a great use of an
> Oracle database. To be more precise every servlet inherits a base servlet
> which opens a database connection at the start of the servlets run and
> closes it when the run finished. This looks to me like a real system killer
> as load increases and I am currently looking at solutions to implement
> connection pooling.
Do it! It will increase the performance significantly since opening an
connecition to the database is a costly action.
>
> What I need to try to find out in the short term is how many connections
> Oracle can handle before it chokes on the load and what sort of magnitude of
> performance degradation we are likely to see as we approach this figure. If
> anyone has any experience of this kind of issue any input would be greatly
> appreciated.
Depends on the load of the systems. How many users are comming by? How many
concurrent users do you have. Mostly the connecions are only needed for a very
short time so the connection dies off pretty quickly. One connection costs a
bout 2MB of RAM on the oracle server. So do some math and you know how
much resources are needed for the server.
So the current set up will work. And will problably hold for quite some time
but connection pooling will both benefit the servlets since the connection do
not need to be opened time after time and because this allows you to compute
the ammount of memory you want to spent on connection on the oracle server.
Wouter
--
Mphasis Media BV. Interactive architects
Wouter Boers <[EMAIL PROTECTED]> http://www.MphasiS.com
Phone: +31 (0)23 5573447 Fax: +31 (0)23 5655132
Wouter Boers <[EMAIL PROTECTED]> http://www.ikke.net
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
