Inserting asyncronously into Oracle, any benefits?

Posted by Karl Trumstedt on Stack Overflow See other posts from Stack Overflow or by Karl Trumstedt
Published on 2010-05-26T10:29:44Z Indexed on 2010/05/26 10:31 UTC
Read the original article Hit count: 208

Filed under:
|
|

I am using ODP.NET for loading data into Oracle. I am bulking inserts into groups of a 1000 rows each call.

Is there any performance benefits in calling my load method asynchronously? So say I want to insert 10000 rows, instead of making 10 calls synchronously I make 10 calls asynchronously.

My database is using ASSM right now but otherwise plenty of freelists are used of course. The database server has several cores as well.

My initial tests seem to point to a performance increase, but maybe there is something I cannot see? Potential deadlock or contention issues?

Of course, there is added complexity in handling transactions and such doing my load this way.

© Stack Overflow or respective owner

Related posts about Performance

Related posts about Oracle