View Single Post
Old 09-08-2016, 11:28 PM   #1597
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Quote:
Originally Posted by kovidgoyal View Post
FYI SQLITE by default (and apsw since it tries to stay as close to sqlite as possible) works in auto-commit mode. So unless you explicitly open a transaction every execute is auto-committed.
Yes, I'd forgotten about that. I removed a pile of commits when I changed to apsw as they weren't going to be needed. In this particular place, I could see committing separately might be a good idea, but it also needs a transaction to be opened first.
davidfor is offline   Reply With Quote