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

Reply via email to