On 1/14/17, Simon Slavin <slav...@bigfraud.org> 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 d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users