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


in reply to DBD::Sqlite queries slow - and gives wrong results

Hello astroboy,

why do you  $dbh->rollback; ?

L*

PS then I suppose you need transactions and commit when you've done.

PPS have you checked for database and table fragmentation? To compact the db with VACUUM can help in such cases.

There are no rules, there are no thumbs..
Reinvent the wheel, then learn The Wheel; may be one day you reinvent one of THE WHEELS.