Bulk Insert to Oracle using .NET

by

I’m loading 50,000 records in 15 or so seconds using Array Binding in ODP.NET

It works by repeatedly invoking a stored procedure you specify (and in which you can do updates/inserts/deletes), but it passes the multiple parameter values from .NET to the database in bulk.

Instead of specifying a single value for each parameter to the stored procedure you specify an array of values for each parameter.

Oracle passes the parameter arrays from .NET to the database in one go, and then repeatedly invokes the stored procedure you specify using the parameter values you specified.

http://www.oracle.com/technetwork/issue-archive/2009/09-sep/o59odpnet-085168.html

/Damian

More Related Contents:

  1. BadImageFormatException. This will occur when running in 64 bit mode with the 32 bit Oracle client components installed
  2. How to connect to Oracle 11 database from . net
  3. store image in database or in a system file? [closed]
  4. SQL Identity (autonumber) is Incremented Even with a Transaction Rollback
  5. Can you use Microsoft Entity Framework with Oracle? [closed]
  6. SELECT * FROM X WHERE id IN (…) with Dapper ORM
  7. Parameterized Queries with LIKE and IN conditions
  8. Using “GO” within a transaction
  9. Managed ODP.NET driver does not show up in Data Source dialog
  10. Does End Using close an open SQL Connection
  11. Does this code prevent SQL injection?
  12. Sanitize table/column name in Dynamic SQL in .NET? (Prevent SQL injection attacks)
  13. How do I write LINQ’s .Skip(1000).Take(100) in pure SQL?
  14. How to cancel a long-running Database operation?
  15. How can you name the Dataset’s Tables you return in a stored proc?
  16. How can I create database tables from XSD files?
  17. How can I avoid SQL injection attacks in my ASP.NET application?
  18. Why is some sql query much slower when used with SqlCommand?
  19. Is it possible to send a collection of ID’s as a ADO.NET SQL parameter?
  20. How can I configure Entity Framework to automatically trim values retrieved for specific columns mapped to char(N) fields?
  21. Does ODP.NET require Oracle Client installation
  22. How do I convert a string into safe SQL String?
  23. Regular expression to find all table names in a query
  24. How to return a page of results from SQL?
  25. Using a variable for table name in ‘From’ clause in SQL Server 2008
  26. How do I select all the columns from a table, plus additional columns like ROWNUM?
  27. Error message “Unable to install or run the application. The application requires stdole Version 7.0.3300.0 in the GAC”
  28. ASP.NET MVC 3 Model Binding Resources
  29. Oracle Parameters with IN statement?
  30. Visual Studio CPU High Usage

Leave a Comment