in reply to Re:x3 It works, it's fast, and it's scalable!
in thread DBI - Oracle 8 - Load many rows into a temp table w/o using SQL*Loader
I thought about that after I posted my response... But I still think that the overhead for all those transactions (even without the commit) would still be higher than a nice, fast bulk load.
I'll benchmark it and post the results here -- after my coffee break. :)
I'll benchmark it and post the results here -- after my coffee break. :)
In Section
Seekers of Perl Wisdom