vertx-sql-client
vertx-sql-client copied to clipboard
Add to PgPool more options for connection handling
We are using thew new vertx reactive SQL client for our reporting microservice. Sometimes reports are very heavy and those queries run too much time and the microservice stucks
So I want to cut too long queries using some maximal query time. Also sometimes we get stale, old DB connections.
In c3p0, in another microservice I solve those problems by using datasource options lie
- Max connection age
- test query
- unreturned connection time out
Is it possible to add this functionality to PgPool?
This is a much needed option! We are currently solving this in the application level by maintaining timers for running queries.
It will be great to have this natively supported in the client