Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

Re: sql loader vs perl dbi

by Corion (Pope)
on Jul 30, 2008 at 18:12 UTC ( #701201=note: print w/ replies, xml ) Need Help??


in reply to sql loader vs perl dbi

Usually, the database vendors maintain and supply their bulk loading utility for a reason - you can't beat sqlldr (or in my case, isql) for their raw loading speed. They are able to circumvent some of the API restrictions that the rest of the database interface needs to follow.

I recommend you look into writing the control file and then shell out to sqlldr to load your data. A templating system will make generating the control file very convenient.

A second route could be to see whether Oracle supports something like LOAD TABLE..., that is, an SQL/DBI interface to sqlldr. That will likely only work on the machine where the database process lives, but you could get a nicer API for error reporting that way than when parsing command output.


Comment on Re: sql loader vs perl dbi
Select or Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://701201]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (5)
As of 2014-09-21 12:26 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (168 votes), past polls