Re^4: Issue with dbi connect

Thank you Corion for the revert.
Here lexical scoped variable $dbh has been used (not a global one), so here it should have been created a new connection, isn't it? but somehow it seems to act as a global variable.
Is there any downside if I retain the "connect" itself instead of "connect_cached", at least for this problematic part of the code.

Please suggest.
Regards,

Comment on Re^4: Issue with dbi connect_cached method

Replies are listed 'Best First'.
Re^5: Issue with dbi connect_cached method by Corion (Patriarch) on Apr 22, 2022 at 17:45 UTC
The point of the `->connect_cached` method is to keep a global cache of the connection. In an ideal world, `->connect_cached` is a drop-in replacement for `->connect`, but reusing an old connection. The downside of using `->connect` is that maybe you are a bit slower because you rebuild the network connection. But that is better than having a long timeout, in your case.	[reply] [d/l] [select]