MySql connection managment with web app

Question

I have a number of servlets (Spring MVC, Rest et...) which all need a database connection

I have a MYSQL database and I use mysql-connector-java-5.1.20-bin.jar to make the connection

The servlets get hit a few hundred times a hour each and I want to improve performance

So how can the current design be improved? (current system is each request into the platform is handled by a servlet which creates a DB connection)

score 2 · Accepted Answer · edited May 23 '17 at 11:49

2

current system is each request into the platform is handled by a servlet which creates a DB connection

Also See

edited May 23 '17 at 11:49

Community

answered Jun 05 '12 at 15:59

jmj

Connection pooling is definately something you should look into. – Namphibian Jun 05 '12 at 16:09
will look into the pool built into tomcat – user1177292 Jun 05 '12 at 18:42

1 Answers1