In memory databases can have rollbacks if they're using journal mode memory.
The last sentence there is a little confusing...
"Note that the journal_mode for an in-memory database is either MEMORY or OFF
and can not be changed to a different value. An attempt to change the
journal_mode of an in-memory database to any setting other than MEMORY or OFF
is ignored. Note also that the journal_mode cannot be changed while a
transaction is active"
...it seems to say you can't change it, but then says if you do change it...
For the transaction benefits you might be right, or it might be the case where
having them in a transaction saves some disk flushes while it's going on. I.e.
in both autocommit and journal_mode off you'll be making changes directly to
the main file with no rollback journals. But with autocommit it'll be syncing
the file after each statement whereas with the transaction it might wait until
the commit to sync. Not sure on that though.
An in memory database with journal_mode off I'm pretty sure will see no
benefits from transactions.
These are my edumacated guesses anyway. Please trust the actual experts more
than me.
-Original Message-
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.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
operations in a transaction? Is that true for in-memory databases as well?
--
This message, and any attachments, is for the intended recipient(s) only, may
contain information that is privileged, confidential and/or proprietary and
subject to important terms and conditions available at
http://www.bankofamerica.com/emaildisclaimer. If you are not the intended
recipient, please delete this message.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users