On Thu, Jan 9, 2014 at 8:29 AM, dd <durga.d...@gmail.com> 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 d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users