I am not a user of Norton but I expect it has the same features as others. In Windows Defender you can specify files to exclude and that may help.
*Jim Dodgen* On Mon, Nov 9, 2015 at 8:44 AM, Richard Hipp <drh at sqlite.org> wrote: > 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 > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >