Page 1 of 2

Better db connection pool?

Posted: Thu Dec 19, 2013 8:56 pm
by jurchiks
Saw this posted on aCis:
https://github.com/brettwooldridge/HikariCP
Seems like a serious project, in active development, good documentation... Worth a try IMHO.

Re: Better db connection pool?

Posted: Thu Dec 19, 2013 10:14 pm
by janiko
Interesting :)

Re: Better db connection pool?

Posted: Fri Dec 20, 2013 5:04 am
by lion

Re: Better db connection pool?

Posted: Fri Mar 07, 2014 1:39 am
by Pandragon
The benchmark seems amazing, but will it really make any notable difference?

Image

Re: Better db connection pool?

Posted: Fri Mar 07, 2014 1:47 am
by NosBit
Well i have tested it some months ago it had some bugs so we decided c3p0 is better for now maybe if project matures a bit we can switch.

Re: Better db connection pool?

Posted: Fri Mar 07, 2014 2:05 am
by Zoey76
C3p0 is active and I know some of the developers, it's not bleeding edge tech, but it's very robust, we could make core to accept different pool managers :twisted:

Re: Better db connection pool?

Posted: Fri Mar 07, 2014 10:48 am
by jurchiks
Well, aside from the bugs in HikariCP (what kind of bugs anyway? maybe they're really minor?), c3p0 can't compare in performance. If we don't use it, adding support for it would be good for those who want to experiment, and for possible future switch.

Re: Better db connection pool?

Posted: Fri Mar 07, 2014 11:03 am
by NosBit
jurchiks wrote:Well, aside from the bugs in HikariCP (what kind of bugs anyway? maybe they're really minor?), c3p0 can't compare in performance. If we don't use it, adding support for it would be good for those who want to experiment, and for possible future switch.
It had poor error reporting some SQL exceptions were getting hidden(related to connection and retry) also some configs were not doing what they were described to or were half working.

Re: Better db connection pool?

Posted: Fri Mar 07, 2014 11:14 am
by Zoey76
Nos wrote:also some configs were not doing what they were described to or were half working.

So like L2j :lol:

Re: Better db connection pool?

Posted: Fri Mar 07, 2014 12:14 pm
by jurchiks
Aaand that is terrible because? Sounds like minor issues that can be fixed in a jiffy. Contributing config renames is easy, that should be accepted pretty quickly. The error reporting thing also shouldn't be a problem if you can argumentate your reasoning properly.

Re: Better db connection pool?

Posted: Fri Mar 07, 2014 2:03 pm
by Battlecruiser
Zoey76 wrote:
Nos wrote:also some configs were not doing what they were described to or were half working.

So like L2j :lol:
especially drop ones :lol:

Re: Better db connection pool?

Posted: Fri Mar 07, 2014 2:15 pm
by janiko
can anyone make diff patch to test HikariCp ?

Re: Better db connection pool?

Posted: Sun Jul 12, 2015 9:57 pm
by Zoey76
Not sure if better, but as promised https://github.com/L2J/L2J_Server/tree/ ... ionFactory

Re: Better db connection pool?

Posted: Mon Jul 13, 2015 1:07 am
by St3eT
I like those graphs which every project have almost same just as main actor is their project. Anyway those projects looks nice in testing phase and on live with lot of ppl starting real fun.

Re: Better db connection pool?

Posted: Mon Jul 13, 2015 3:01 am
by Zoey76
St3eT wrote:I like those graphs which every project have almost same just as main actor is their project. Anyway those projects looks nice in testing phase and on live with lot of ppl starting real fun.
Sdw, UnAfraid and you said the same, I guess you didn't used it properly, since I used it on an application that get hit by 500 transactions per second all of them with database access and it performed well after proper configuration. :+1: