As mentioned earlier, transactions allow savings in file access time usually (especially in the uber-leet SQLite driver). Another thing to try is to do $dbh->prepare() on the insert query with param placeholders. Most drivers will then cache the compiled state of the query, cutting out a chunk of used time later on.