mojolicious / mojo-pg

Mojolicious :heart: PostgreSQL
https://metacpan.org/release/Mojo-Pg
Artistic License 2.0
101 stars 46 forks source link

Optimize connection cache #59

Closed kraih closed 4 years ago

kraih commented 4 years ago

The connection cache currently performs a $dbh->ping on every dequeue. That's rather expensive and there might be more efficient solutions, such as using $dbh->{Active}. We should look into this.

kraih commented 4 years ago

PRs would be very welcome for this.

kraih commented 4 years ago

This might be the best we can do https://github.com/mojolicious/mojo-pg/compare/581995ce510c...9b7e3bfde04c.