On Fri, Dec 17, 2010 at 2:17 AM, Max Vlasov <max.vla...@gmail.com> wrote:

> 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?
>

There is currently no mechanism to indicate when SQLite runs recovery.


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



-- 
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to