On 8/4/17, 1:28 PM, "sqlite-users on behalf of Nico Williams" <[email protected] on behalf of [email protected]> wrote: > Imagine a mode where there is only a WAL, and to checkpoint is to write a new > WAL with only live contents and... rename(2) into place. Such a mode would > a) be a 100% Copy-on-Write (CoW) mode, whereas currently WAL is only CoW > until a checkpoint operation comes along, b) have better read concurrency. A > special marker could be used to denote "this WAL is closed and replaced with > a checkpointed one", that way readers only have to stat/re-open when they see > this.
A log-structured database, like a log-structured file system? _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

