in reply to SQLite Slow insert
As you don't show us how your database is constructed, or how you open the DB connection, it's somewhat hard to guess.
I suggest looking at the Performance section of the DBD::SQLite documentation. Consider whether loading the data in an atomic transaction is OK for you. Also see http://bobby-tables.com/, because your way of constructing the insert statement is liable to fail with embedded single quotes. Use placeholders there.
In Section
Seekers of Perl Wisdom