Re: [sqlite] journal mode and transactions

2017-12-22 Thread David Raymond
- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Nelson, Erik - 2 Sent: Friday, December 22, 2017 11:10 AM To: SQLite mailing list Subject: [sqlite] journal mode and transactions The transactions documentation (https://sqlite.org/lang_transaction.ht

[sqlite] journal mode and transactions

2017-12-22 Thread Nelson, Erik - 2
The transactions documentation (https://sqlite.org/lang_transaction.html) states >If PRAGMA journal_mode is set to OFF (thus disabling the rollback journal file) then the behavior of the ROLLBACK command is undefined. Does that correspondingly mean there's no performance benefit to wrapping

Re: [sqlite] Journal mode

2013-03-18 Thread Richard Hipp
On Mon, Mar 18, 2013 at 8:29 PM, Jeff Archer < jsarc...@nanotronicsimaging.com> wrote: > Documentation doesn't make this clear. Does PRAGMA journal_mode = OFF; > affect a single connection or will it affect all connections in my process? > Single connection. -- D. Richard Hipp d...@sqlite.org

[sqlite] Journal mode

2013-03-18 Thread Jeff Archer
Documentation doesn't make this clear. Does PRAGMA journal_mode = OFF; affect a single connection or will it affect all connections in my process? ___ sqlite-users mailing list sqlite-users@sqlite.org