It depends on the database engine, but I know for certain that Oracle
connections react badly to being used in a child after being created in the
parent. Most other databases probably will too.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
----- Original Message -----
From: "Eric Kolve" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, March 11, 2001 7:46 PM
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.
