Inserting asyncronously into Oracle, any benefits?
- by Karl Trumstedt
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.