Poor performance with ODP.net parameter array inserts when record contains BLOBs

Question

I use ODP.net parameter arrays to achieve batch insert of records. This way performs very well when the records don't contain BLOB column - typically about 10,000 records can be inserted in one second.

If a record contains BLOB column, it has a poor performance - about 1,000 records need 8 ssconds.

Is there any method to batch insert records with BLOB column efficiently.

seacat · Accepted Answer · 2012-08-09 09:39:40Z

1

I find I use odp to insert record with blob column uncorrectly.

when insert record with blob column, I use byte array to store the blob value. this way will have a poor performance. I replace another way, use OracleBlob type to store the blob value. In this way, batch insert records will have a high performance.

answered Aug 9, 2012 at 9:39

seacat

376 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Iúri dos Anjos Over a year ago

You have the same results when reading a Blob column or only when inserting? Comparing inserting as byte array vs OracleBlob

Collectives™ on Stack Overflow

Poor performance with ODP.net parameter array inserts when record contains BLOBs

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related