On 01/16/2014 02:20 AM, Steven Fisher wrote:
After opening, I want to do some basic checking of my database.
I’m finding integrity_check much too slow for some of my users (especially with
large amounts of data) but I don’t want to just blindly trust the database
either.
A few options:
- Rely on what sqlite does on its own when I start actually using the database
- Test for particular tables I expect
- Something else
Any thoughts?
You could try this:
http://www.sqlite.org/pragma.html#pragma_quick_check
Dan.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users