There's more than one way to do things | |
PerlMonks |
Re^3: performance problem with oralce dbdby adrianh (Chancellor) |
on Apr 15, 2004 at 18:37 UTC ( [id://345494]=note: print w/replies, xml ) | Need Help?? |
This is untested since I don't have an Oracle box to hand to play with. Were you doing a commit after every insert with the SQL you sent to sqlplus? If not I suspect that changing AutoCommit => 0 and doing an explicit commit every few hundred inserts will speed things up considerably.
In Section
Seekers of Perl Wisdom
|
|