On 29 Mar 2013, at 6:42pm, Jeff Archer <jsarc...@nanotronicsimaging.com> wrote:
> But shouldn't transactions be disabled when journal_mode = off? No. The two things have nothing to do with one-another. Transactions are about grouping changes together so that either they all happen or none happen. Journalling is about surviving through crashes and power-failures, and being able to undo changes. Transactions are about programming. Journalling is about hardware failure. Either one can be useful without the other. Having seen you ask this question probably explains your earlier confusion. So yes, if you're doing trials, you have four test cases: (transactions on and off) times (journalling on and off) = 2 x 2. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users