Overhead on using DB connection pool

Question

I have a bunch of java programs that are run every few minutes. These programs are started by a script every few minutes and terminates in less than a minute. Most of them are single threaded and to access MySQL DB I use:

DriverManager.getConnection()

They just need to connect once, and execute a query. Now I'm adding a new program to this group which is multi threaded and all the threads need to access DB concurrently. I'm thinking of using a DB connection pool (c3p0) for this.

My question is, as all these programs share a common DAO for accessing DB, is there an overhead of using a DB connection pool for the single threaded programs even though they just need one connection? I'm planning to set initialPool size to 1, min pool size to 1 and max pool size to 10.

Community · Accepted Answer · 2017-05-23 12:21:31Z

2

The main goal of connection pools is to have some ready-to-use connections, rather then open and close each time you want to get a connection. This approach saves quite enough time in terms if DB is used quite often.

Apache DBCP is single-threaded, but anyway it significantly increases performance, if your application uses DB connection very often.

c3p0 is a good choice, but for choosing proper connection pool please check this discussion: Connection pooling options with JDBC: DBCP vs C3P0

edited May 23, 2017 at 12:21

CommunityBot

11 silver badge

answered Feb 27, 2013 at 18:09

n1ckolas

4,4503 gold badges39 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

kriver Over a year ago

My question is if there is any performance issue on using a DB Connection Pool with just one connection vs just obtaining a connection using DriverManager.getConnection()

n1ckolas Over a year ago

There shouldn't be any performance issues at least just because you won't close Connection at all. Since you are planning to set maxPoolSize to 10, then in this case ConnectionPool is a best choice as there won't be any locks. The only thing to consider is that ConnectionPool needs external libraries, meanwhile DriverManager.getConnection() needs only JDK.

Collectives™ on Stack Overflow

Overhead on using DB connection pool

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related