Hello eCap, Monday, January 21, 2002, 10:45:37 PM, you wrote:
e> A newbie question here... e> I have a requirement to spin off a SQL loader process after a web page (a e> form which is qualified and accepted) has been submitted. Does it make e> sense, or more importantly, is it dangerous to apply a "fork" at the end of e> a module such as this: e> sub handler { e> # do some qualification stuff here and accept the form submission... e> if ($pid = fork) { e> # parent e> # ...whatever i need to accomplish to deliver return html code e> return OK e> } elsif { e> # child e> exec($sql_loader); e> } else { e> # ...whatever i ned to do to recover errors e> return DECLINED e> } e> } e> Are there any dangers in doing something like this? Or is there a more e> efficient way to accomplish the same thing? e> Thanks for the advice, e> Kirk I'm recently implement exactly such loader. From the client HTTP request I'm starting loader with double fork approach. I'm loading posssible large enough (about 100 - 150 MB) data from DBF flat files into Oracle in single transaction (I'm must provide consistency). Loader process takes about 40-50 min to complete and consumes many resources (CPU and RAM). But it works ! -- WBR, Mike P. Mikhailov mailto:[EMAIL PROTECTED] Pessimests are right more often, but optimists are happy more often