Hello, We have an application that runs under windows that use sqlite to store data. Our application do a pragma integrity_check every time It's launched.
One of our users have our application with a database of 180 Mb and It takes about 6 minutes to complete a Pragma integrity_check the first time that our application is launched after reboot computer. Is it normal that takes so much time to complete the Pragma integrity check ? The application during the pragma integrity_check do an intensive use of hard disk. Then if the user launches the application another times without rebooting computer It only tooks 8 seconds to complete the prama integrity_check and It don't use the hard disk. We supose that the other times the database it's cached, but it's a lot of difference between 6 minutes the first time we launched the application and 8 seconds takes to completer after the first launch of our application. And another is it recommended to do a pragma integrity check every time that our applications is launched? Thanks _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
