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.