Re: Class::DBI and fork
- From: xhoster@xxxxxxxxx
- Date: 31 Aug 2005 14:10:41 GMT
"golden" <iang@xxxxxxxxxxxxx> wrote:
.....
> I would now like to have some reports run interactively by a user, but
> some of the has_many relationships take a significant amount of time.
....
> The forking was done with Parallel::ForkManager, but when I run the
> code, I get all sorts of Errors from Class::DBI, but I do not get those
> errors if I remove forking. I suspect that the dbh file handle gets
> trashed during the fork.
>
> Can anybody comment or suggest an alternative?
The best alternative may be to fix your database. If your database can't
efficiently handle one query at a time, slamming it with multiple queries
at a time is just as likely to make things worse as make them better. YMMV
Each child almost certainly needs it's own connection. So make your
database connections after the fork, rather than before. If you need a
database connection before you do the fork, then close that connection
before the fork, and then reconnect after.
If you need a database connection which survives the fork in only one of
the forked processes, (i.e. because a single transaction spans the fork),
then set InactiveDestroy in every process other than the one that still
needs the handle. (And in general, I believe that the one that keeps the
handle active must be the original process, not one of the spawned ones).
Xho
--
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service $9.95/Month 30GB
.
- References:
- Class::DBI and fork
- From: golden
- Class::DBI and fork
- Prev by Date: Re: looking for Perl coder help..
- Next by Date: Re: DBI prepare and fetch
- Previous by thread: Class::DBI and fork
- Next by thread: INTERNAL SERVER ERROR (WIERD???)
- Index(es):
Relevant Pages
|
