Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic

Re: sql loader vs perl dbi

by runrig (Abbot)
on Nov 21, 2012 at 23:22 UTC ( #1005027=note: print w/ replies, xml ) Need Help??

in reply to sql loader vs perl dbi

DBD::Oracle natively supports the 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). sqlldr without direct path will be somewhere in between.

Comment on Re: sql loader vs perl dbi

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (7)
As of 2015-10-08 21:01 GMT
Find Nodes?
    Voting Booth?

    Does Humor Belong in Programming?

    Results (227 votes), past polls