Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer

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.

Comment on Re^6: Fetchrow question

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://960963]
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: (8)
As of 2015-10-07 13:20 GMT
Find Nodes?
    Voting Booth?

    Does Humor Belong in Programming?

    Results (184 votes), past polls