Optimizing $dbh->do()
The default implementation of $dbh->do() calls
prepare(), execute() and finish()for each
invocation of $dbh->do()
This can be optimized for repeated iterations by
hand-preparing the statement but repeatedly
executing the same statement handle
This is very efficient when used with bind
values
DBI: The Neophyte's Guide
60