how about this module for connection caching?
http://search.cpan.org/~timb/DBI-1.636/lib/DBD/Gofer.pm
thanks
On 2016/7/19 17:37, James Smith wrote:
On 7/19/2016 9:58 AM, yhp...@orange.fr wrote:
Jie,
I have been using Apache::DBI, but I don't think it is something like
JDBC.
Thankfully not - JDBC is one of the biggest nightmares our DBAs face -
if we have
network issues (firewall session timeout e.g.) we have had all sorts of
problems with
oracle jdbc connections.
We actually don't even use Apache::DBI (we are primarily MySQL) as the
"uncontrolled"
caching of connections can lead to problems - flooding database servers
with open
connections, connections failing because of firewall issues. We
explicitly cache (and
reconnect) using DBIx::Connector to cope with the few databases we
explicitly want
vast connections...
Admitedly many of our servers have upward of 30-40 apps on them, talking
to 40-50
different databases (quite often on the same server!)
