Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical

Re^6: Fetchrow question

by mje (Curate)
on Mar 22, 2012 at 09:26 UTC ( #960963=note: print w/replies, xml ) Need Help??

in reply to Re^5: Fetchrow question
in thread Fetchrow question

In addition to the excellent advice from roboticus, both DBD::Oracle and now DBD::ODBC (from 1.34) support DBI's execute_for_fetch. You might be wondered why this helps (given the name) with multiple inserts but it is because DBI's execute_array uses execute_for_fetch. With execute_array you can prepare an insert and provide as many rows of data for the parameters as you like and the DBD will send them in batches (thus vastly reducing network traffic). It is usually a lot faster.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://960963]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (3)
As of 2018-02-22 19:29 GMT
Find Nodes?
    Voting Booth?
    When it is dark outside I am happiest to see ...

    Results (298 votes). Check out past polls.