[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] Faster (can be shallow) "integrity_check"?
From:       Zbigniew Baniewski <zb () ispid ! com ! pl>
Date:       2008-10-31 11:51:54
Message-ID: 20081031115154.GA12494 () sarge ! my ! own ! domain ! no-net
[Download RAW message or body]

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
[prev in list] [next in list] [prev in thread] [next in thread]