Re: [sqlite] PRAGMA integrity_check(integer)
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)
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)
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