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
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