Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> java array insert vs. batch
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.
![]() |
![]() |