bulk insert from Java into Oracle

Posted by Will Glass on Stack Overflow See other posts from Stack Overflow or by Will Glass
Published on 2010-04-26T20:56:17Z Indexed on 2010/04/26 23:13 UTC
Read the original article Hit count: 121

Filed under:
|
|

I need to insert many small rows rapidly into Oracle. (5 fields).

With MySQL, I break the inserts into groups of 100, then use one insert statement for every group of 100 inserts.

But with Oracle, user feedback is that the mass inserts (anywhere from 1000-30000) are too slow.

Is there a similar trick I can use to speed up the programmatic inserts from Java into Oracle?

© Stack Overflow or respective owner

Related posts about Oracle

Related posts about java