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