Um, that code is doing the preparing in a loop. You are supposed to do it just a single time. Besides, the parametrised query for $against is counter-productive here (it will waste loads of time if $against is big as you seem to have here). I recommend embedding it to the SQL statement (quote it with $dbh->quote!)