Bug#623619: SQLite WAL mode

2012-02-22 Thread brian m. carlson
On Tue, Feb 21, 2012 at 10:53:33AM +0100, Florian Weimer wrote: > > On Mon, Feb 20, 2012 at 10:03:51AM +0100, Florian Weimer wrote: > >> Have you tried setting "PRAGMA journal_mode = WAL" on the SQLite > >> database, using the sqlite3 command line tool? > > > > Nope. I didn't know it existed. If

Bug#623619: SQLite WAL mode

2012-02-21 Thread Florian Weimer
* brian m. carlson: > On Mon, Feb 20, 2012 at 10:03:51AM +0100, Florian Weimer wrote: >> Have you tried setting "PRAGMA journal_mode = WAL" on the SQLite >> database, using the sqlite3 command line tool? > > Nope. I didn't know it existed. If it's needed for reasonable > performance, it should b

Bug#623619: SQLite WAL mode

2012-02-20 Thread brian m. carlson
On Mon, Feb 20, 2012 at 10:03:51AM +0100, Florian Weimer wrote: > Have you tried setting "PRAGMA journal_mode = WAL" on the SQLite > database, using the sqlite3 command line tool? Nope. I didn't know it existed. If it's needed for reasonable performance, it should be set by default upon installa

Bug#623619: SQLite WAL mode

2012-02-20 Thread Florian Weimer
Have you tried setting "PRAGMA journal_mode = WAL" on the SQLite database, using the sqlite3 command line tool? More information is here: This should reduce the commit overhead. Checkpoints still need fsync, but the are rare. fsync behavi