On Thu, Jan 9, 2014 at 8:29 AM, dd <[email protected]> wrote: > Hi all, > > Executed integrity check for database before application starts. > Sometimes, it takes 1 minute. Other times, it finishes within 2 > seconds. How integrity check works? can somebody explain why it takes > less time. >
PRAGMA integrity_check is suppose to do exactly the same thing every time it is run. I don't know why you are seeing a 30x timing difference. Can you provide us with a test case? -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
