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
