Hi I have a servlet which enables access to a mysql database for about 200 users. It's not heavily used. I currently reuse a single database connection which has worked fine. Have i just been lucky and should i implement a connection pool? frank
Joined: May 05, 2000
Depends on how many concurrent requests you are getting and how long the connection is used per request.
hai, for ur case if at least 200 users are continuously access ur site at any time u can use connection pooling .otherwise it is not recommended. [This message has been edited by saradhi pantra (edited December 03, 2000).]
Joined: Oct 17, 2000
Hi, Can any one explain how to create Connection pool. Thanks in advance....
Joined: Jan 31, 2000
www.coreservlets.com has a very good ConnectionPool class with source. The author is Marty Hall. Please check it out. regds maha anna