Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

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

by Discipulus (Canon)
on Dec 11, 2017 at 20:20 UTC ( [id://1205303]=note: print w/replies, xml ) Need Help??


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.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1205303]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others surveying the Monastery: (6)
As of 2024-04-26 09:20 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found