Re: Loading LOTS of data into Oracle

--


: >>

: >> > We are loading millions of records into an Oracle

: >> > database running on HP-UX on an HP 9000/890.

: >> > Using ProC Oracle can only handle about 24 records

: >> > addition per second.

: >> >

: >> > What kind of optimization would you recommend?




  If you can't use the direct loader (as others have suggested) and require
  PRO*C you should make sure that you are doing "Array Inserts". That is,
  you stuff all of your data into arrays and use the arrays as bind variables.
  See the precompiler guides for details. Try array sizes > 1000 if you can
  tolerate the memory usage.  Your 890 should be able to kick through data
  much faster than 24/sec.


--------------------------------------------------------------
 Joe Ahmann                                      ahmann_at_fs.com
 Fourth Shift Corp.                              (612) 851-1427
 JIT Enterprise Systems