RiotTown has asked for the wisdom of the Perl Monks concerning the following question:

I've got to load roughly 1,000,000 rows of data into an Oracle database daily... using sql*ldr doesn't really work out to well in this instance. I've got other DBA types telling me to use an array insert statement to greatly improve the performance of the inserts, but I've not had much success getting a definitive answer to if this is possible using DBD::Oracle and DBI. Anyone else had any luck with this?

Replies are listed 'Best First'.
Re: DBD::Oracle array inserts?
by arturo (Vicar) on Aug 17, 2001 at 00:21 UTC

    The last I'd heard, support for VARRAYs was in the works, but isn't yet available. Here is some guy ... OK, Tim Bunce ... 's latest public word on the subject. He oughta know, cos' he wrote the module (thanks Tim!)

    If you want to get or are already handy with PL/SQL and/or Java (Oracle 8i), you might look into writing a function to insert a VARRAY.

    HTH.

    perl -e 'print "How sweet does a rose smell? "; chomp ($n = <STDIN>); +$rose = "smells sweet to degree $n"; *other_name = *rose; print "$oth +er_name\n"'
      Not really the answer I was hoping for (more like the one I expected) but you can't win them all... I'll check out the PL/SQL idea. Thanks for the info! - D