Hello ! Thank you for reply !
PRAGMA wal_autocheckpoint; -> 1000 PRAGMA wal_checkpoint; -> busy 0| log 0| checkpointed 0 //database was properly checkpointed before this Have a look at my own reply that try to solve the problem but do not solve redundant checkpoints. Do you know how to do that ? (avoid redundant checkpoints between several applications ?) Cheers ! > Fri Mar 18 2016 03:16:24 PM CET from "Simon Slavin" ><slavins at bigfraud.org> Subject: Re: [sqlite] Wall checkpoint not running > > On 18 Mar 2016, at 2:00pm, Domingo Alvarez Duarte ><sqlite-mail at dev.dadbiz.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. >> > Can you please run these commands and tell us the result ? > > PRAGMA wal_autocheckpoint; > PRAGMA wal_checkpoint; > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > ?
