You are viewing a plain text version of this content. The canonical link for it is here.
Posted to gitbox@activemq.apache.org by GitBox <gi...@apache.org> on 2020/06/29 07:50:42 UTC

[GitHub] [activemq-artemis] uomik commented on pull request #3204: ARTEMIS-2823 Use datasource with JDBC store db connections

uomik commented on pull request #3204:
URL: https://github.com/apache/activemq-artemis/pull/3204#issuecomment-650993888


   > Before on settling down on dbcp. Did you evaluate other connection pool implementations. I remember that dbcp had performance and memory issues in the past (maybe nowadays too?). HikariCP might be a better alternative.
   
   Yes I did evaluate HikariCP and c3p0 (https://www.mchange.com/projects/c3p0/) along with dbcp2. Each of them worked just fine and I saw no noticeable performance difference beween them. Yes there used to be some major performance issues with dbcp2, but to my knowledge the latest version is much better. I did not run any real performance tests with each of the connection pools, but have done it with other applications. Dbcp2 has been slightly slower, but proven to be more reliable in an environment where database drops connections very aggressively, when compared to HikariCP. c3p0 was simply dropped because I'm not that familiar with it.
   
   At the end, I made the choice based on the fact that with default settings dbcp2 was the only one that I got to work flawlessly in our test cluster. Both HikariCP and c3p0 required some extra configuration.


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org