Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

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.

Update: Also, DBIx::BulkUtil makes sqlldr easy.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1005027]
help
Chatterbox?
[choroba]: When I get that, I usually just reply "Good luck" and move on.
[marto]: I'm sure it's only going to be a matter of hours before someone adds that comment
[marto]: or closes the question because it's a almost the same as one someone else asked, years ago...
[marto]: snackoverflow gamification of editorial powers for the win :/
marto should register snarkoverflow
[marto]: nothing to see here people, go about your daily business :P

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (6)
As of 2018-01-23 10:43 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    How did you see in the new year?










    Results (243 votes). Check out past polls.

    Notices?