Dear all, Thank you very much for those advices. I will try them and get back if it does not solve the issue.
Regarding the advice of Simon on HDD starting to fail, I have one more question. In fact, I suspected this, as my client has other problems with his computer. But, in such case, I expected to get logs in Windows Events Journal. I scanned those logs and did not see any logs regarding Hdd problems or related stuff. So, my question is the following : does someone has already experienced performance issues on database with an HDD device starting to fail (without any corruption problem) ? And if yes, is it possible that those performance issues come with no notification in the windows log journal ? Thanks in advance, Brice 2015-11-09 17:39 GMT+01:00 Simon Slavin <slavins at bigfraud.org>: > > On 9 Nov 2015, at 3:21pm, Brice Andr? <brice.andre at ams-solutions.be> > wrote: > > > So, does someone has an idea on what can cause such performance issues on > > some sqlite DB requests ? > > Since you > > 1) are getting delays and not errors, and > 2) you are using very common OS and hardware, and > 3) you are accessing a database from an internal disk, > > I strongly suspect that any fault is not in SQLite. From experience this > sort of problem is caused by either > > A) an anti-virus package or > B) a hard disk which is just starting to fail and will get worst until it > fails completely > > Diagnosis and fixes should relate to trying a different disk or > temporarily disabling the anti-virus software, not to anything inside > SQLite. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >