>Date: Thu, 28 Mar 2013 14:13:51 +0100 >From: ibrahim <ibrahim.a...@googlemail.com> > >... You should compare > >a) Journal mode=on w/wo single transaction >b) Journal mode=off w/wo single transaction
So, this means I can use transaction when I have journal_mode = off? I did not understand that this was a possibility? I have re-read the PRAGMA journal_mode documentation and still it sounds to me like this cannot be done: "The OFF journaling mode disables the atomic commit and rollback capabilities of SQLite." Maybe I am not reading throughly... Maybe all it truely says definitively is "Applications must avoid using the ROLLBACK command when the journal mode is OFF." I will rerun my experiment with a single transaction with journal_mode = off. Thanks. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
