Java Application-JDBC Pooling-Performance Boosting

[ulvi ugur]

Hi All,

Do you think if JDBC Connection Pooling can increase throughtput performance for a Java application ? We are talking about a performance of 4000 inserts/second of 2KBytes records.

Thanks in advance,

Ulvi

[Leandro Coutinho]

take a look here: http://www.javaranch.com/journal/200601/JDBCConnectionPooling.html

hth

[ulvi ugur]

Hi,

Thanks for the reference but I am not sure if the article is applicable for my case as I am _not_ running any servlet/beans which represent many users with a lot of intermittent requests. In my case, I have only one application and main question is if it makes sense to use more than one connection to increase performace.

Any additional comments ?

Thanks again,

Ulvi

[Leandro Coutinho]

Well, you don't need to create more connections than you are using. What you can do is avoid to open and close connections, and instead you use a connection pool. Take a look in c3p0 -> http://www.mchange.com/projects/c3p0/index.html

I don't know if it is useful to your case. Try to execute the inserts in batch.

I'm just learning this subject as well, so wait for others replies and do your own search. =)

Other interesting links:
http://www.precisejava.com/javaperf/j2ee/JDBC.htm
http://www.ibm.com/developerworks/data/library/techarticle/dm-0708calio/
http://www.javaperformancetuning.com/tips/jdbc_batching.shtml
http://en.wikipedia.org/wiki/Connection_pool

[ulvi ugur]

Hi,

After some weeks, I can answer my own post; more connections simply increase the performance there. Running 50-60 simultaneous connections in multi-threads increased our performance like 30-40 times.

Thanks for the replies anyways.

Ulvi