Thanks, Jeffery- and Ryan Hope too, who also suggested this. Sounds like a great idea and I'll give it a try!! I really appreciate it.
Becka -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 1:47 PM To: Rebecca Louden Cc: [EMAIL PROTECTED]; 'Michael A Chase' Subject: RE: fork and DBI on Win 2000 Actually, it's not impossible at all. However, the way you need to do it is to pass the connect string or instance name for the database to your child process and let the child process create its own connection, rather than passing the already created connection to the child. You wind up with a lot more connections this way, but unless you are updating or inserting, this shouldn't be a problem. If you are updating or inserting, you need to be concerned with making certain that any process modifying a table completes before another one starts, etc... We actually have an application that runs our entire data warehouse load process this way. ******************************* Jeff Seger Data Warehouse Engineer Fairchild Semiconductor [EMAIL PROTECTED] ******************************* Rebecca Louden <RLouden@collectam To: "'Michael A Chase'" <[EMAIL PROTECTED]>, erica.com> [EMAIL PROTECTED] cc: 05/16/2002 02:07 Subject: RE: fork and DBI on Win 2000 PM Uh oh. Then is what I want to do possible at all? Is there no way to launch several SQL scripts at the same time, using a Perl script? Thanks, Becka -----Original Message----- From: Michael A Chase [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 12:13 PM To: Becka; [EMAIL PROTECTED] Subject: Re: fork and DBI on Win 2000 On 16 May 2002 16:29:33 -0000 Becka <[EMAIL PROTECTED]> wrote: > I am missing out on a concept, I hope someone can help. (I'm getting an access > violation when I run my script.) What I want to do is write a script that > connects to the database, forks several processes (which will actually be > executions of prepared statements, which call SQL scripts), and then exits. My > entire goal is to run several executions simultaneously. Oracle does not allow parents and children to share database connections. As a result the behavior of DBD::Oracle when you try to do it is often unpleasent. -- Mac :}) ** I normally forward private questions to the appropriate mail list. ** Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age.
