vertx-sql-client icon indicating copy to clipboard operation
vertx-sql-client copied to clipboard

Add minSize to pool to maintain a minimum # of connections

Open kdubb opened this issue 2 years ago • 7 comments
trafficstars

Motivation:

Adds a minSize parameter to pool options to ensure a minimum # of connection is always connected and available.

Conformance:

You should have signed the Eclipse Contributor Agreement as explained in https://github.com/eclipse/vert.x/blob/master/CONTRIBUTING.md Please also make sure you adhere to the code style guidelines: https://github.com/vert-x3/wiki/wiki/Vert.x-code-style-guidelines

kdubb avatar Apr 23 '23 23:04 kdubb

Hi @tsegismont - this change looks good to me. Do you think someone more familiar with this code can approve it? Thank you.

chandramouli-r avatar Apr 25 '23 23:04 chandramouli-r

@tsegismont is out until May 2nd

@vietj you have any thoughts on this one?

kdubb avatar Apr 26 '23 04:04 kdubb

Hi, @vietj - any thoughts on this PR? I think it looks ready to merge. Thanks!

chandramouli-r avatar May 01 '23 01:05 chandramouli-r

Hi @tsegismont - any further thoughts on this PR?

chandramouli-r avatar May 03 '23 16:05 chandramouli-r

I am wondering if that should not be a feature that is directly in the pool instead of being specific to this implementation

vietj avatar May 11 '23 09:05 vietj

Is this feature still considered for inclusion ? We would also need it in our applications, since we often experiment steep peaks where the concurrent establishment of many new DB connections can become a bottleneck. So far we have to resort to a scheduled task that periodically checks for the pool size and opens connections so that it reaches the min size. This is of course best-effort only and by no means perfect, but it still helps keeping some connections open.

tmonney avatar Jul 12 '24 14:07 tmonney

@tmonney yes it is considered, I haven't looked back at this PR but according to my comments, I had doubts about the actual PR

vietj avatar Jul 13 '24 10:07 vietj