Re^2: DBD::Sqlite queries slow - and gives wrong results

Short-Answer: Do This Now: “Bracket all of your SQLite calls, whether(!) read or write, in transactions.”

He's already using transactions; see the connection parameter 'AutoCommit=>0' or TIAS:

$ perl -MDBI -e 'my$d=DBI->connect("dbi:SQLite:dbname=x.db","","",{Aut
+oCommit=>0}); $d->begin_work or die "ah, of course! *HEADWHACK*\n"'
DBD::SQLite::db begin_work failed: Already in a transaction at -e line
+ 1.
ah, of course! *HEADWACK*
[download]

Comment on Re^2: DBD::Sqlite queries slow - and gives wrong results - HEADWHACK Download Code