Any ideas?

This kind of unwillingness on the part of databases often means the omission of commit (be it explicit or as autocommit).

Try a $dbh->commit; at the end (or every few thousand inserts).

If that's not it, a small self-sufficient testcase would help (but including connection params, create table, some minimal data).