On 1/24/06, John Siracusa <[EMAIL PROTECTED]> wrote: > On 1/24/06, Rob Kinyon <[EMAIL PROTECTED]> wrote: > > According to the DBI docs under the description of the execute() > > method, it says: > > > > If any arguments are given, then C<execute> will effectively call > > L</bind_param> for each value before executing the statement. > > ...the key word being "effectively." I'm operating under the pleasant > assumption (delusion? :) that what DBI does internally during > execute() is more efficient than me calling through bind_param() > repeatedly "from the outside."
Check out the code for execute_array() in DBI.pm - you'll be surprised. The code for execute() is somewhat harder to find and it does do things in XS/C as opposed to Perl. However, the overhead is so minuscule as compared to the overhead of using RDBO to begin with that I would put the bind_param() calls in and provide a parameter to turn it on/off at the user's leisure. Rob ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid3432&bid#0486&dat1642 _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
