Bob Ebert wrote: > Is journal_mode a future optimization? The atomic commit documentation > (http://sqlite.org/atomiccommit.html) as well as the pragma docs > (http://www.sqlite.org/pragma.html) make tantalizing references to this > potentially useful optimization, but I've searched the 3.5.1 and 3.5.8 > sources and I can't find any mention of journal_mode switches in the > source. It appears as if 3.5.x behaves as if this pragma were set to > DELETE. > > Ah, ok, more digging in the wiki suggests that this isn't a released > feature yet, it's post-3.5.8. Anyone care to speculate on when this > will hit release?
Regarding the new PRAGMA journal_mode: Since PERSIST is likely to be faster than DELETE on most platforms, is there ever a reason *not* to use it? Put differently, is there any advantage to DELETE over PERSIST? - Richard Klein _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users