in reply to large number of placeholders

This is probably more of a SQL problem than a Perl problem. I suggest you add the line warn "Statement: $temp"; right before the prepare call, and make sure your SQL statement is what you expect it to be. (In particular, do you need to quote the values? If you do, the $dbh->quote() method might be your friend.)

--Brent Dax
There is no sig.