>From: "James K. Lowden" <jklow...@schemamania.org> >To: sqlite-users@sqlite.org > > Your experiment is telling you different: transaction control costs more than I/O. But shouldn't transactions be disabled when journal_mode = off? Maybe that is a faulty assumption. If so, what is the point of journal_mode = off? For this purpose, I am very happy to give all the ACID promises.
If I understand your point #2, I think you are saying that all of the inserts within a single transaction are not written to the disk (database or journal) until the transaction is committed. But that can't quite be the answer because if kept my transaction open long enough I would simple run out of memory and that doesn't seem to happen even when I have 1 million plus inserts. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
