Re: 20000 INSERTs per second?

From: Karsten Schmidt <groups_at_karsten-schmidt.com>
Date: 24 Apr 2003 01:53:01 -0700
Message-ID: <c6711ac4.0304240053.55aab2@posting.google.com>

Hi,
you certainly need to use some kind of array processing, like a couple of hundred rows with one statement. Not sure how to do that in java though.
I remotely recall that there is something like statement.addBatch() or so.

In Pro C / OCI there are array interfaces available.

the bottelneck with that number of inserts is probably redolog generation / writing, make sure you do not commit too often. a large logbuffer is probably also going to help.

64 bit should'nt really matter.

For the maximum possible throughput on your hardware, check out sqlldr with conventional load.

Karsten

ibm_97_at_yahoo.com (JZ) 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 Thu Apr 24 2003 - 03:53:01 CDT