Re: DBI insert statement

[erix]

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).

[cbtshare]

thank you tried, that but got this message: "commit ineffective with AutoCommit enabled "