Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re: Keep a Database Connection Active and Reuse it Between Script Executions?

by talexb (Canon)
on Feb 04, 2020 at 19:38 UTC ( #11112386=note: print w/replies, xml ) Need Help??


in reply to RESOLVED - Keep a Database Connection Active and Reuse it Between Script Executions?

    After talking to some coworkers who have more database experience than I do, they thought the issue might be that I'm connecting/disconnecting to the DB too often (I'm attempting to get in touch with our Oracle DBA team to ask them as well).

This is hilarious -- it anthropomorphizes the database into a being that will get frustrated with your rapid connection/disconnection behaviour, and stop answering. I'm pretty sure there's no database setting that limits the number of connections made in a time period. :)

Alex / talexb / Toronto

Thanks PJ. We owe you so much. Groklaw -- RIP -- 2003 to 2013.

  • Comment on Re: Keep a Database Connection Active and Reuse it Between Script Executions?

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (3)
As of 2021-10-23 05:15 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My first memorable Perl project was:







    Results (86 votes). Check out past polls.

    Notices?