Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change

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 rifling through the Monastery: (6)
As of 2015-11-26 15:30 GMT
Find Nodes?
    Voting Booth?

    What would be the most significant thing to happen if a rope (or wire) tied the Earth and the Moon together?

    Results (701 votes), past polls