You can have many statement handles for each dbh. I think this is what you
are refering to.
$dbh = DBI->connect(.....);
$sth = $dbh->prepare(.....);
$sth2 = $dbh->prepare(......);
$sth->execute();
$sth2->execute();
Each query is bound to it's statement handle where all of the statment
handles can then in fact be bound to one dbh.
Ilya Sterin
-----Original Message-----
From: drdoctor [mailto:drdoctor]On Behalf Of Eric Kolve
Sent: Sunday, March 11, 2001 11:25 PM
To: [EMAIL PROTECTED]
Subject: sharing dbh across forked children
Is it possible to share a database handle initialized in a parent with
forked children ? What I want to do is process a file which needs to
execute many SELECT statements in parallel. I am wondering if each
child needs to instantiate its own dbh or whether you can execute sql
simultaneously against the same dbh.
thanks,
--eric
