Class::DBI and fork
- From: "golden" <iang@xxxxxxxxxxxxx>
- Date: 31 Aug 2005 04:46:45 -0700
Hi,
I have been using class DBI for generating reports and till now most of
the work has been done off-hours so performance was not quite an issue.
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.
So, for my inventory system, I was thinking about taking a list of
products from a user and forking parallell processes for each product
to get all relationships. Each fork would write to a separate file,
then I can reap all the files after completing all products.
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?
Thanks,
.
- Follow-Ups:
- Re: Class::DBI and fork
- From: xhoster
- Re: Class::DBI and fork
- Prev by Date: Re: array question (newbie)
- Next by Date: Re: split, no repeat- Regular expression
- Previous by thread: split, no repeat- Regular expression
- Next by thread: Re: Class::DBI and fork
- Index(es):
Relevant Pages
|
