Turn off AutoCommit and manually commit your inserted rows ever 100 rows or so. The code is Class::DBI-ish but should be easily adapted to whatever your needs are:

package ASE::DB;
use strict;
use base 'Class::DBI';

__PACKAGE__->set_db( Main => "dbi:SQLite:dbname=d:/data/ase.sqlite",""
+,"", 
  {RaiseError => 1, AutoCommit => 0} );
[download]

Of course, then you have to commit at least at the end of your program run, or whenever a work unit has been processed:

    ASE::DB->db_Main->commit;
[download]