in reply to DBI - need for speed

Excelent ideas!

I'll dig up one of our Oracle DBA's and see if he's got a trick up his sleeve for the initial run. I failed to mention in my original post that after the first few runs of 8000 the load should reduce to about 3000 records and about 100 inserts per day (data maintenance).

Either way, I'll benchmark this perl method and see if it will fit in our service levels. If it misses the mark then I'll conjure up some SQL scripts and load it directly.

Thanks again for your ideas.