Hi Pradeep,
u can store connection objects of a user in session objects(seems to be the
normal thing which should be done in database related servlets).
U can read "Sessions" and "advanced JDBC techniques" chapters of Jason
Hunter's book. They discuss improving performance of servlet applications
using JDBC.
I think u can share connection objects for different users(at least for
only select queries) by writing class member variables. But for proper
transactions u will have to deal with synchronization issues also.
--Mukul
At 12:22 PM 7/15/99 +0900, pradeep wrote:
>Hi All
>
>I am modifying a site to which the number hits per month is very
>high.earlier it was implemented with CGI scripts and now I am changing it to
>3-tier web application with Servlets on web server..
>
>When evaluated the pros and cons I am strucked up with the question of
>solving the scalability problem.I can not keep on generating connections to
>the database in response to the client request to query the database(this
>will bring the performance down) at the same time I am unable to find a
>suitable solution by which I can satisfy the user request with a very high
>database performance..
>
>Is there any method by which I can have some limited m-number(a very
>moderate number) of connections answering all the requests???
>
>Any suggestions please?
>
>TIA
>-pradeep
___________________________________________________________________________
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
