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