On Fri, Dec 17, 2010 at 2:47 AM, Richard Hipp <d...@sqlite.org> wrote:

> On Thu, Dec 16, 2010 at 4:12 PM, Marc <cpm...@gmail.com> wrote:
>
> > application.
> >
> > And another is it recommended to do a pragma integrity check every time
> > that
> > our applications is launched?
> >
>
> PRAGMA integrity_check is only recommended after a hard crash - that is to
> say an operating system lock-up or a power loss.  Your application crashing
> is not sufficient grounds for an integrity_check.
>
>

Richard, is there consistent way to know that a restoring operation occurred
after the open? I suggested name analizing prior to optn (searching for
-journal file), but what about wal mode? is there any visual indication that
the job was stopped during the checkpointing?

Max Vlasov
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to