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
Thomas Paul
mister krabs
Ranch Hand
Joined: May 05, 2000
Posts: 13974
posted
0
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).]
satishind Reddy
Ranch Hand
Joined: Oct 17, 2000
Posts: 33
posted
0
Hi, Can any one explain how to create Connection pool. Thanks in advance....
Regards Satish
maha anna
Ranch Hand
Joined: Jan 31, 2000
Posts: 1467
posted
0
www.coreservlets.com has a very good ConnectionPool class with source. The author is Marty Hall. Please check it out. regds maha anna
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to
run our stuff on 16 servers instead of 3.
0
