Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re: DB Connection pool

by perrin (Chancellor)
on May 07, 2002 at 04:47 UTC ( [id://164526]=note: print w/replies, xml ) Need Help??


in reply to DB Connection pool

First, connection pools do not avoid multiple connections to a database. What they do is limit the overall number of connections open at any given time and re-use them between parallel threads or processes. They may reduce the number of connections needed at one time, but only if some of the threads aren't doing any database work.

Second, you don't need one. Just fork processes for the number of connections you want, connect separately in each (after the fork) and go. That's the most efficient you can get with this.

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others browsing the Monastery: (3)
As of 2024-04-16 03:49 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found