http://www.perlmonks.org?node_id=1055016


in reply to DBI::SQLite slowness

You must perform SQLite operations in a transaction, because if you do not, it will re-read and re-verify e-v-e-r-y I/O operation, by design.

In Section Seekers of Perl Wisdom