Near the end of the POD for DBD::SQLite you'll find a discussion about performance. The author claims that SQLite is very fast. He does mention, however, that INSERT is not particularly fast, especially if you're committing each INSERT one by one. He gives the example of inserting 400,000 rows using transactions, and only committing every thousand rows. There are also other performance tips in that last section of the POD.