Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> java array insert vs. batch

java array insert vs. batch

From: <velonews_at_gmail.com>
Date: 12 Oct 2006 21:29:56 -0700
Message-ID: <1160713796.270871.207270@e3g2000cwe.googlegroups.com>


All,

o/s = CentOS
db = 9.2 and 10.2
driver = jdbc (thin)
platform: two (2) dual core xeons 32-bit 2G ram local storage raid-0 (I know, I know)

Target Outcome:
insert records as fast as possible w/ java proggy

Currently the best I can do w/ sqlldr (as a benchmark) is about 3K recs/sec (sqlldr invoked on db machine itself). java proggy (making net connection) is handcuffed at about 2K inserts/sec

Thanks for any, all suggestions.

Received on Thu Oct 12 2006 - 23:29:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US