Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re: Best practices for closing database connections?

by davido (Cardinal)
on Mar 17, 2022 at 14:25 UTC ( [id://11142181]=note: print w/replies, xml ) Need Help??


in reply to Best practices for closing database connections?

Let DBIx::Connector handle the issues around long-lived database connections, such as dropped connections. It's a really good module for this sort of thing. It is a lot more efficient to keep a frequently used DB connection open, but then you have to start dealing with handles going dead on you for various reasons. DBIx::Connector manages this so you don't have to.


Dave

  • Comment on Re: Best practices for closing database connections?

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://11142181]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others admiring the Monastery: (3)
As of 2025-12-07 15:23 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    What's your view on AI coding assistants?





    Results (85 votes). Check out past polls.

    Notices?
    hippoepoptai's answer Re: how do I set a cookie and redirect was blessed by hippo!
    erzuuliAnonymous Monks are no longer allowed to use Super Search, due to an excessive use of this resource by robots.