Daniel wrote:
Is it safe do set PRAGMA synchronous = OFF when a
transaction-safe file system is used?
We are working on WinCE with TFAT (see below) - but this might
be a general question.
TFAT:
... By making file operations
transaction-safe, TFAT stabilizes the file system and
ensures
Thank you for your comments.
Karl Tomlinson wrote:
One thing I'm trying to understand is whether there was a reason for
SQLite choosing to use a rollback journal (of the steps to undo a
transaction) rather than a replay journal (of the steps to perform a
transaction).
I didn't make
Igor Tandetnik writes:
Karl Tomlinson wrote:
I really meant, as a first possibility, that writing the pages
to the database itself would be performed during the commit
process after syncing the replay journal (but the database need
not be synced until the journal is about to be removed
I've done a little looking into journals, fsyncs, and filesystems recently.
One thing I'm trying to understand is whether there was a reason for SQLite
choosing to use a rollback journal (of the steps to undo a transaction) rather
than a replay journal (of the steps to perform a transaction).
In