On 11/9/15, Brice Andr? <brice.andre at ams-solutions.be> wrote: > OK, but if this scenario was at the origin of my problem, I guess I would > have such a log each time a db query freezes ? > > If yes, then there is probably another problem, as I am sure I got such > freezes with no such logs from sqlite. > > By the way, if the antivirus is at the origin of the problem, which > practical solution may I find to the problem ? I cannot request my client > to deactivate his antivirus. And he is using a very common one (norton). > So, I would probably not be the only one to have this problem ? > > Is there a way to request SQlite to don't release control of the file > between two operations ? As I only open one descriptor, this could maybe > help if it was possible ? Maybe I could ask sqlite to take control of the > file at the beginning of my program, and request it to release control at > the end ? >
If you run your large update inside a transaction, it should run to completion without getting interference from AV software. -- D. Richard Hipp drh at sqlite.org