Mercurial > p > roundup > code
diff CHANGES.txt @ 6930:a96a239db0d9
Set all sqlite db's to WAL mode on creation
Complete work done on 6917:fba76e0bba98.
WAL journaling mode now enabled on primary db as well as session db's
when using sqlite for session databases.
Made change to WAL mode more robust for testing by bracketing
`pragma journal_mode=wal` with commit() calls. Normally the conversion
would occur when a new session was opened, but this commits the changes
explicitly to make all the tests stable.
Also added doc on this.
| author | John Rouillard <rouilj@ieee.org> |
|---|---|
| date | Thu, 08 Sep 2022 01:12:12 -0400 |
| parents | 9ff091537f43 |
| children | bd2c3b2010c3 |
line wrap: on
line diff
--- a/CHANGES.txt Wed Sep 07 10:55:31 2022 -0400 +++ b/CHANGES.txt Thu Sep 08 01:12:12 2022 -0400 @@ -59,6 +59,9 @@ - sqlite native-fts backend now uses the stopwords list in config.ini to filter words from queries. (Stopwords are still indexed so that phrase/proximity searches still work.) (John Rouillard) +- sqlite databases use WAL mode when *created* to improve read + concurrency. Existing sqlite database still use rollback journal + mode. See upgrading.txt for details. (John Rouillard) 2022-07-13 2.2.0