Re: [sqlite] Faster (can be shallow) "integrity_check"?

2008-10-31 Thread Zbigniew Baniewski
On Fri, Oct 31, 2008 at 06:43:29PM +0700, Dan wrote: > You could use "PRAGMA quick_check", which is similar to integrity_check > but runs more quickly. Yes, it's much faster - but still much too time-consuming to make it default (more than 10 additional seconds on ~300 MB database file). > Note

Re: [sqlite] Faster (can be shallow) "integrity_check"?

2008-10-31 Thread Dan
On Oct 31, 2008, at 6:34 PM, Zbigniew Baniewski wrote: > I would to make automatic test of the database integrity each time > before > accessing, just to avoid the problems with broken files, which are > resulting > in error message: "database disk image is malformed". > > Unfortunately,

[sqlite] Faster (can be shallow) "integrity_check"?

2008-10-31 Thread Zbigniew Baniewski
I would to make automatic test of the database integrity each time before accessing, just to avoid the problems with broken files, which are resulting in error message: "database disk image is malformed". Unfortunately, "PRAGMA integrity_check" takes very long time. Does there exist any