On 2015/11/09 6:33 PM, Brice Andr? 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 ?
Actually, you are not the only one. This problem has been discussed here a lot and is very common. Keeping updates in transactions may help, but a lot of the time you have no control over how many times a user requests things from the DB. Having the Antivirus exclude the folder (or DB file at a minimum) usually helps for us. (It's part of our systems' documentation even). All this assumes it /IS/ in fact the anti-virus causing the problem - you need to check that first. Best of luck! Ryan
