Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Re: Batch Upload/Insert Row wise with Perl DBI

by runrig (Abbot)
on Sep 27, 2011 at 16:33 UTC ( #928117=note: print w/ replies, xml ) Need Help??


in reply to Batch Upload/Insert Row wise with Perl DBI

According to the docs, you can use the ArrayTupleFetch attribute in the execute_array() method, but I don't see how it's any better than what morgon provided above (unless your db really does some sort of batch/bulk load in this situation).


Comment on Re: Batch Upload/Insert Row wise with Perl DBI
Re^2: Batch Upload/Insert Row wise with Perl DBI
by mje (Curate) on Sep 28, 2011 at 07:56 UTC

    FYI, some DBDs handle execute_array etc themselves often allowing many rows of data to be sent to the database in one go. DBD::Oracle is one. If you look at the tests in DBD::Oracle and 26exe_array.t you can find examples.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (10)
As of 2015-07-06 23:05 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (85 votes), past polls