It's probably better to use a single db connection for the same script rather than opening one up several times when needed. I would not be surprised that the latter would see a lot of time spent in the database connection phase compared to a single DBI connection.

That said, you can still do one single dbh connection, and simply modify your subs in the separate files to handle this concept. That is, instead of a sub like this:

sub
Write_Bar
{
$dbh->do("INSERT INTO bar (Foo,Fob,Fib) VALUES ('baz','biz','boz')");
}
[download]

You can have it like this instead:

sub
Write_Bar
{
my $dbh = shift;
$dbh->do("INSERT INTO bar (Foo,Fob,Fib) VALUES ('baz','biz','boz')");
}
[download]

and make sure that you pass the dbh when you call those subs.

-----------------------------------------------------
Dr. Michael K. Neylon - mneylon-pm@masemware.com || "You've left the lens cap of your mind on again, Pinky" - The Brain
"I can see my house from here!"
It's not what you know, but knowing how to find it if you don't know that's important