On 1/14/17, Simon Slavin <[email protected]> wrote: > > Given your 5 indexes, 30 minutes to check an 11GB file is completely > reasonable. Don’t worry about that. >
PRAGMA integrity_check looks into a lot of detail - such as verifying that every entry in the table has the correct corresponding entry in each index. That takes time. If you run instead "PRAGMA quick_check" SQLite checks each table and index separately, but does not cross-check them for consistency, which can be much much faster, especially on a large database. Try running "PRAGMA quick_check" and see if it isn't done in 30 seconds instead of 30 minutes. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
