Class::DBI and fork

[golden]

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:BI, 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,

 

[xhoster]

.....

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:BI, 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