Re: 20000 INSERTs per second?

From: Joseph Wilson <me_at_home.now>
Date: Sat, 26 Apr 2003 02:59:39 GMT
Message-ID: <vCmqa.484$mD5.213468@dca1-nnrp1.news.algx.net>

As far as the Java/JDBC part, the fastest way would be to create one preparedstatement. Then loop through your data, set the bind variables and add the statement via the addBatch() method. Every so often do an execute batch. How often will depend on your data and your setup so do some testing. Also, be sure to set autocommit to false in your connection. Commit based on your setup, as infrequently as possible.

Others have answered your question concerning the db side of things.

Joe

"JZ" <ibm_97_at_yahoo.com> wrote in message news:10bc841c.0304231047.5bc925ad_at_posting.google.com...
> Oracle 9.2.0.3 enterprise for Solaris 2.8
> I like to know whethere it's possible to accomplish 20000 INSERTs (through
> JDBC drive, not pure INSERT SQL) per second on Oracle 9.2.0.3.
> If so, should we go with RAC or high end storage (to improve disk I/O)?
> Any docs about this or any suggestions to improve INSERTation rate
> through JDBC driver?
> Can 64bit environment improve this?
> Thanks a lot!
Received on Fri Apr 25 2003 - 21:59:39 CDT