SQLite Forum

PRAGMA INTEGRITY_CHECK takes very long
Login
Normal.  It has to read every piece of data in the table and its indexes, and do a lot of cross-referencing.

There's a different check which reports some integrity problems, but doesn't test as many things:

<https://sqlite.org/pragma.html#pragma_quick_check>

It's faster and may do enough for your purposes.