Forums Register Login

Connection pool - Own implementation / DBCP / c3p0

+Pie Number of slices to send: Send
We have our own connection pool implementation. I am thinking of implementing connection pool using DBCP / C3P0. Can we get better performance using DBCP / c3p0 than our own connection pool implementation ?
+Pie Number of slices to send: Send
 

kri shan wrote: Can we get better performance using DBCP / c3p0 than our own connection pool implementation ?


Probably. Your implementation is highly unlikely to be optimized (or bug free for that matter.)
+Pie Number of slices to send: Send
This falls under the category of 'reinventing the wheel'. There are people spending a lot of time and energy building things like database connection pools and unless you have a strong belief these implementations are flawed, better to use their work.

Reminds me of an old programmer adage... "Good programmers write good code, great programmers steal good code. "
+Pie Number of slices to send: Send
 

kri shan wrote:We have our own connection pool implementation. I am thinking of implementing connection pool using DBCP / C3P0. Can we get better performance using DBCP / c3p0 than our own connection pool implementation ?



You might want to have a look at BoneCP - according to my benchmarks, available on the site, it's faster than both C3P0 and DBCP.

Disclaimer: I'm the author so I can't be unbiased

I'm all tasted up for a BLT! This tiny ad wants a monte cristo!
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 2497 times.
Similar Threads
connection pool ? (JBoss / DBCP / c3po )
Database Connection pool in struts
How to configure c3p0 connection pool weblogic ??
Connection Pool
Spring Framework and Hibernate
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 29, 2024 07:09:31.