Task #3662

PRAGMA synchronous = NORMAL for higher reliability

Added by hans over 3 years ago. Updated over 3 years ago.

Status:ClosedStart date:08/19/2014
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:-
Target version:0.2 - reliability and cacheword interop
Component:

Description

try switching to NORMAL synchronous in sqlfs_t_init(). WAL mode only performs fsync on checkpoint operation, which reduces overhead. It should make it possible to run with synchronous set to NORMAL with less of a performance impact. (sqlfs originally did not use WAL mode).

Associated revisions

Revision 106446ab
Added by Hans-Christoph Steiner over 3 years ago

PRAGMA synchronous = NORMAL for higher reliability

Using the WAL mode should reduce the performance hit of using sync mode
enough to be usabel.

https://www.sqlite.org/pragma.html#pragma_synchronous

fixes #3662 https://dev.guardianproject.info/issues/3662

History

#1 Updated by hans over 3 years ago

  • Target version set to 0.2 - reliability and cacheword interop

#2 Updated by hans over 3 years ago

  • Status changed from New to Resolved

#3 Updated by Anonymous over 3 years ago

Applied in changeset libsqlfs|commit:106446abfc7dcab4b783b3fe96a2f5fcb34e0bfc.

#4 Updated by hans over 3 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF