Better db connection pool?

jurchiks · Post by **jurchiks** » Thu Dec 19, 2013 8:56 pm

Saw this posted on aCis:
https://github.com/brettwooldridge/HikariCP
Seems like a serious project, in active development, good documentation... Worth a try IMHO.

janiko · Post by **janiko** » Thu Dec 19, 2013 10:14 pm

Interesting

Post by **lion** » Fri Dec 20, 2013 5:04 am

https://forum.zone-game.info/showthread.php?t=32757

Pandragon · Post by **Pandragon** » Fri Mar 07, 2014 1:39 am

The benchmark seems amazing, but will it really make any notable difference?

Post by **NosBit** » Fri Mar 07, 2014 1:47 am

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.

Post by **Zoey76** » Fri Mar 07, 2014 2:05 am

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

jurchiks · Post by **jurchiks** » Fri Mar 07, 2014 10:48 am

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.

Post by **NosBit** » Fri Mar 07, 2014 11:03 am

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.

Post by **Zoey76** » Fri Mar 07, 2014 11:14 am

Nos wrote:also some configs were not doing what they were described to or were half working.

So like L2j

jurchiks · Post by **jurchiks** » Fri Mar 07, 2014 12:14 pm

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.

Post by **Battlecruiser** » Fri Mar 07, 2014 2:03 pm

Zoey76 wrote:
Nos wrote:also some configs were not doing what they were described to or were half working.

So like L2j

especially drop ones

janiko · Post by **janiko** » Fri Mar 07, 2014 2:15 pm

can anyone make diff patch to test HikariCp ?

Post by **Zoey76** » Sun Jul 12, 2015 9:57 pm

Not sure if better, but as promised https://github.com/L2J/L2J_Server/tree/ ... ionFactory

St3eT · Post by **St3eT** » Mon Jul 13, 2015 1:07 am

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.

Post by **Zoey76** » Mon Jul 13, 2015 3:01 am

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.

L2J Server

Better db connection pool?

Better db connection pool?

Re: Better db connection pool?

Re: Better db connection pool?

Re: Better db connection pool?

Re: Better db connection pool?

Re: Better db connection pool?

Re: Better db connection pool?

Re: Better db connection pool?

Re: Better db connection pool?

Re: Better db connection pool?

Re: Better db connection pool?

Re: Better db connection pool?

Re: Better db connection pool?

Re: Better db connection pool?

Re: Better db connection pool?