in reply to Re^5: Mass inserts with SQLite + CSV + execute_array?
in thread Mass inserts with SQLite + CSV + execute_array?

Yea. I double that.

This makes a huge difference.

$dbh->{AutoCommit} = 0;
and then execute your inserts.
And then $dbh->commit.

This will make something like this anything from ten to 100 times faster.

  • Comment on Re^6: Mass inserts with SQLite + CSV + execute_array?

In Section Seekers of Perl Wisdom