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) Cheers ! * * > Fri Mar 18 2016 03:50:30 PM CET from "Richard Hipp" <drh at sqlite.org> >Subject: Re: [sqlite] Wall checkpoint not running > > On 3/18/16, Domingo Alvarez Duarte <sqlite-mail at devdadbiz.es> wrote: > > >>I have a database with more than 12,000,000 rows in one table and around >>6GB >> in size, it's in wall mode and when I run this program the wall file grows >> unbound, it doesn't seem that the checkpoint is doing any work. >> >> I read the documentation and as I understood the automatic checkpoint >>should >> be running in this case (only this application has the database open and >> only >> one connection and no threads). >> >> > Did you read this: https://www.sqlite.org/wal.html#bigwal > > -- > D. Richard Hipp > drh at sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > ?
