hi pradeep,
you can use connection pooling, you can go to archives of this list and
there you can find links to many connection pool classes available on the net.
Regards
Nitin.
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
___________________________________________________________________________
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
