Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Re: Connection Pooling

by Happy-the-monk (Monsignor)
on Jun 10, 2013 at 10:39 UTC ( #1038039=note: print w/ replies, xml ) Need Help??


in reply to Connection Pooling

Now the issue is that opening 200+ connections to database.

You can do any number of operations with an (any one) open database connection.

Compare all the tables you like, just don't close the connection in-between table comparisons.

Cheers, Sören

(hooked on the Perl Programming language)


Comment on Re: Connection Pooling
Re^2: Connection Pooling
by venu_hs (Novice) on Jun 10, 2013 at 11:03 UTC

    Yes we can do all the table validations using one connection.

    Since to reduce the comparison time, i am runnig this script on different servers for different tables. Now i cannot have a database connection persistent across servers.

    At the maximum, i can have one open connection per server. But again controlling the opening and closing of connections on different servers would be difficult unless you have a control mechanism.

    This is the reason why we are trying to implement connection pooling

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (13)
As of 2014-10-01 13:15 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    What is your favourite meta-syntactic variable name?














    Results (19 votes), past polls