http://www.perlmonks.org?node_id=998480


in reply to Re: Using a single database handle or multiple handles
in thread Using a single database handle or multiple handles

If your subs comprise transactions and you need to close the connection after each, you would let the sub set up the connection.

This seems a somewhat strange procedure, or construction. Transactions are committed or rolled back by telling the database to COMMIT or ROLLBACK (and dbi can do either), not by closing the connection...

  • Comment on Re^2: Using a single database handle or multiple handles