On Thu, Feb 20, 2014 at 7:41 PM, veeresh kumar <veeru...@yahoo.com> wrote:
> Haven't measured the time, but I have seen a pause before commit > happens. As stated during my earlier discussion, my service cannot pause > for more than 10 sec as it would be result in time out for the clients that > are connected to this service. > > What my understanding towards the checkpoint is taking my below settings > as example, WAL size would never grow beyond 1MB because check point occurs > after WAL file size reaches 1 MB. Please correct me if I am wrong. > > Long-running or overlapping readers can prevent the checkpoint from occurring. The checkpoint will be retried again and again, but if there is always a read transaction open on a transaction other than the most recent transaction, the the checkpoint will never have an opportunity to run to completion and reset the WAL file. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
