Exactly. If you will be executing a statement multiple times, you only need prepare it once. This will save time.

$update=<<UPDATE;
update foo
set bar = ?
where id = ?
UPDATE

$dbstmt = $dbhandle->prepare($update);

foreach $recid (keys %records) {
  $dbstmt->execute($newvalues{$recid}, $recid);
}
[download]