Right. Here's a bit of code I used recently to explore these issues. It uses (the very nice) Parallel::ForkManager, although the fundamentals are the same for normal forking. Since each handle lives in its own process, transactions are unique to each one, which is a boon for efficiency and makes it safe to have multiple users writing to the DB:

#!/usr/bin/perl 
use strict;
use warnings;
use Parallel::ForkManager;
use constant NUM => shift; # number of children to spawn.

my $pfm = new Parallel::ForkManager(NUM);
my $id = 0; # a unique id for each process

# a sub to be run *from within the parent thread* at child creation.
my $init = sub {
  my ($pid, $ident) = @_;
  print "++ $ident started, pid: $pid\n";    
};

# a sub to be run *from within the parent thread* at child termination
+.
my $finalize = sub {
  my ($pid, $exit_code, $ident) = @_;
  print "-- $ident finalized, pid: $pid\n";
};

# set the subrefs
$pfm->run_on_start($init); 
$pfm->run_on_finish($finalize);

# now for the fun bit. 
for(1..NUM) {

  # spawn a new process and break to begin the next iteration, as each
+ 
  # child process will continue the loop but the parent should not. 
  my $pid = $pfm->start(++$id) and next;
  $main::db = DBI->connect( ... );  # use your specific  initializatio
+n args

  # Do your stuff, sit in a loop to service requests, etc.

  $main::db->commit(); # or rollback, or something depending on condit
+ions.
  $main::db->disconnect();
  $pfm->finish(); # exterminate! exterminate!
}

# make sure we don't leave any zombies roaming about.
$pfm->wait_all_children();
[download]

Now if you're running 5.8, you may have the option of sharing the database handle between threads, although I haven't been able to test this yet. Probably though you'd want to take advantage of the stringent separation of data between threads so you'd have similar behavior as when forking.

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.