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 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.
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. =)
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
Good night. Drive safely. Here's a tiny ad for the road:
a bit of art, as a gift, that will fit in a stocking