Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re: DBI::SQLite slowness

by Anonymous Monk
on Sep 20, 2013 at 12:47 UTC ( #1055016=note: print w/ replies, xml ) Need Help??


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.


Comment on Re: DBI::SQLite slowness
Replies are listed 'Best First'.
Re^2: DBI::SQLite slowness
by Endless (Beadle) on Sep 20, 2013 at 17:59 UTC
    If I simply have "$dbh->commit" following the For loop, is that effectively the same as explicitly using transactions?
      If I simply have "$dbh->commit" following the For loop, is that effectively the same as explicitly using transactions?

      No; BEGIN WORK (or BEGIN TRANSACTION or just plain BEGIN) starts a transaction in SQL. Then (normally after 1 or more insert/delete/update's) COMMIT commits the transaction (or, when an error occurs, ROLLBACK rolls the transaction back to the state just before the BEGIN).

      See DBI's begin_work

      (I don't use SQLite; in the above I am assuming SQLite does this the same way that other (RDBMS) databases do)

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (10)
As of 2015-07-28 12:03 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (254 votes), past polls