Re: 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

Replies are listed 'Best First'.
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	[reply]

Replies are listed 'Best First'.

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

[reply]