Re: [sqlite] Faster (can be shallow) "integrity_check"?
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 that "PRAGMA quick_check" is currently an undocumented experimental > feature. It has been present for almost a year though. But will it be present for steady from now on? -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Faster (can be shallow) "integrity_check"?
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, "PRAGMA integrity_check" takes very long time. Does > there > exist any possibility to make a much shorter test, for just very > obvious > cases, like incomplete database file (when f.e. there has been taken > just > part of the database file during downloading)? You could use "PRAGMA quick_check", which is similar to integrity_check but runs more quickly. Note that "PRAGMA quick_check" is currently an undocumented experimental feature. It has been present for almost a year though. Dan. > > -- > pozdrawiam / regards > > Zbigniew Baniewski > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Faster (can be shallow) "integrity_check"?
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 possibility to make a much shorter test, for just very obvious cases, like incomplete database file (when f.e. there has been taken just part of the database file during downloading)? -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users