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

Does each fork create it's own database connection ?

How do you insert the records? one at a time or in batches? If you're looking for speed it's usually best to batch your inserts into one transaction. So turn autocommit off and handle them yourself.

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

Replies are listed 'Best First'.
Re^2: Fork a new process for inserting a record in DB (Oracle) by Anonymous Monk on Nov 07, 2013 at 14:19 UTC
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...	[reply]
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]