On 3/18/16, Domingo Alvarez Duarte <sqlite-mail at dev.dadbiz.es> wrote: > Hello ! > > Thanks for reply ! > > Yes I read it and realize that I'm suffering "*Checkpoint starvation"*, see > my own reply where I tried to solve this but I'm not sure how to > synchronize, > coordinate several applications to do not make redundant checkpoints. > > Any idea on how to achieve it ? (no redundant checkpoints beween several > applications) >
It's automatic. There is nothing you have to do to make this happen. Automatic checkpoints are run by the committer for any commit after which the WAL file is above a threshold size. Hence only one thread (the commiter) is trying to do the checkpoint. -- D. Richard Hipp drh at sqlite.org
