Re: [sqlite] Pragma integrity_check takes a lot of time to complete

2010-12-17 Thread Richard Hipp
On Fri, Dec 17, 2010 at 2:17 AM, Max Vlasov max.vla...@gmail.com wrote: On Fri, Dec 17, 2010 at 2:47 AM, Richard Hipp d...@sqlite.org wrote: On Thu, Dec 16, 2010 at 4:12 PM, Marc cpm...@gmail.com wrote: application. And another is it recommended to do a pragma integrity check every

[sqlite] Pragma integrity_check takes a lot of time to complete

2010-12-16 Thread Marc
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

Re: [sqlite] Pragma integrity_check takes a lot of time to complete

2010-12-16 Thread Simon Slavin
On 16 Dec 2010, at 9:12pm, Marc wrote: 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. Why ? If you distrust your platform that much, you probably shouldn't use it at all. One of our users

Re: [sqlite] Pragma integrity_check takes a lot of time to complete

2010-12-16 Thread Max Vlasov
On Fri, Dec 17, 2010 at 12:12 AM, Marc cpm...@gmail.com wrote: And another is it recommended to do a pragma integrity check every time that our applications is launched? to the things Simon wrote I'd add another variant for you. Your program can detect presence of journal file during the

Re: [sqlite] Pragma integrity_check takes a lot of time to complete

2010-12-16 Thread Richard Hipp
On Thu, Dec 16, 2010 at 4:12 PM, Marc cpm...@gmail.com wrote: 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

Re: [sqlite] Pragma integrity_check takes a lot of time to complete

2010-12-16 Thread Max Vlasov
On Fri, Dec 17, 2010 at 2:47 AM, Richard Hipp d...@sqlite.org wrote: On Thu, Dec 16, 2010 at 4:12 PM, Marc cpm...@gmail.com wrote: application. And another is it recommended to do a pragma integrity check every time that our applications is launched? PRAGMA integrity_check is only