Re: [sqlite] PRAGMA integrity_check(integer)

2009-08-24 Thread Chang Im (chim)
Hi Simon,

> > I have SQLite 2.x database and sometimes it takes a long time to run
> > "integrity_check" on the database.
> 
> How long ?  Minutes ?  Hours ?
> 
> Simon.

I have one database file which "pragma integrity_check" never comes back
from.
I am using "sqlitebrowser 1.1".

-chang
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] PRAGMA integrity_check(integer)

2009-08-21 Thread Simon Slavin

On 21 Aug 2009, at 10:44pm, Chang Im (chim) wrote:

> I have SQLite 2.x database and sometimes it takes a long time to run
> "integrity_check" on the database.

How long ?  Minutes ?  Hours ?

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] PRAGMA integrity_check(integer)

2009-08-21 Thread Chang Im (chim)
Hi,

I have SQLite 2.x database and sometimes it takes a long time to run
"integrity_check" on the database.
Looking at the integrity_check option "(integer), we could control how
many errors to return from the check.

I tried the option, but it generated a syntax error.

Is the option supported?  If so, does it stop the cmd after specified
number of errors?

Thanks.
-chang
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users