Re^2: Fork a new process for inserting a record in DB (Oracle)

Yes. I'm opening a DB connection for each thread and closing the connection. When I run the script... it just runs fine for first few seconds.... and then throws the above error...

Comment on Re^2: Fork a new process for inserting a record in DB (Oracle)

Replies are listed 'Best First'.
Re^3: Fork a new process for inserting a record in DB (Oracle) by talexb (Chancellor) on Nov 07, 2013 at 14:25 UTC
Wow. That's a completely brutal way of doing it. Think of how much work is involved in setting up a database connection, doing one insert, and then tearing down that connection. A better way might be to split the data into 20 chunks, and then pass each of the chunks to a separate process. Alex / talexb / Toronto Thanks PJ. We owe you so much. Groklaw -- RIP -- 2003 to 2013.	[reply]