Don't use DBI for mass inserts. All databases have some kind of bulk loading tools which are massively faster than SQL statements. Use them, and use perl to prepare the CSV file or whatever it is that the loader wants as input.