<?xml version="1.0" encoding="windows-1252"?>
<node id="1005027" title="Re: sql loader vs perl dbi" created="2012-11-21 18:22:24" updated="2012-11-21 18:22:24">
<type id="11">
note</type>
<author id="31503">
runrig</author>
<data>
<field name="doctext">
[cpan://DBD::Oracle] natively supports the [http://search.cpan.org/perldoc?DBD::Oracle#execute_array|execute_array] method, and it is quite fast. Maybe not quite as fast as sqlldr, but it should get through 200,000 records (in batches of 1000 or so) in no time. sqlldr with direct path might be the fastest, but direct path has it's own issues that should be considered (e.g. letting you insert duplicates leaving unique constraints in a disabled state).</field>
<field name="root_node">
701197</field>
<field name="parent_node">
701197</field>
</data>
</node>
