Oracle Bulk inserts through ADO.NET (C#) - Can't use ODP

Trying to do oracle bulk inserts quickly, im currently doing 4000 rows in about 110 seconds...awful! I do have my inserts tied to a transaction and only commit once the transaction is completed. I am binding parameters to the OracleCommand for input.

I'm using ADO.NET with C# parsing through the OCI. ODP.NET is real开发者_如何学Cly not an option because I cannot sacrifice portability. I want to distribute the application, and a few DLLs..not an oracle client install!

Any ideas on how I can speed this up?

---

My advice is to use ODP.net. That's going to be the best way to get this running more smoothly.

To get around the install a client problem, take a look at this Oracle forums thread on a DLL only deployment that you can bundle with your app. It's MUCH more compact then a full Oracle client install, and doesn't require any kind of installation.

---

Please note that System.Data.OracleClient is deprecated according to http://msdn.microsoft.com/en-us/library/system.data.oracleclient.aspx

IF a commercial library is an option (min. 2 DLLs) take a look at http://www.devart.com/dotconnect/oracle/ - it has a "direct mode" which works without any client install and it can use OCI if present...