Re: [WebDNA] online.db deadlock: your current options ...
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106928
interpreted = N
texte = Yes, antivirus software on Windows is notorious for grabbing exclusive =file locks on large files, and even worse: the scan gets triggered every =time the file is modified. Turn off virus scanning for db files, because =those are not executables anyway.Also, best to wrap an [ExclusiveLock]...[/ExclusiveLock] around the =outside of all that visitor-counter code, because all it takes is two =visitors to hit the site simultaneously to cause the DB to deadlock. =You'll run into this on any multithreaded programming language.On Jul 11, 2011, at 4:01 PM, Stuart Tremain wrote:> I just had a though ..... it could be virus checking software that is =causing the problem !>=20> If you disallow the SW from accessing .db files that may solve the =problem. I must check my own configuration !!
Associated Messages, from the most recent to the oldest:
Yes, antivirus software on Windows is notorious for grabbing exclusive =file locks on large files, and even worse: the scan gets triggered every =time the file is modified. Turn off virus scanning for db files, because =those are not executables anyway.Also, best to wrap an
[exclusivelock]...[/ExclusiveLock] around the =outside of all that visitor-counter code, because all it takes is two =visitors to hit the site simultaneously to cause the DB to deadlock. =You'll run into this on any multithreaded programming language.On Jul 11, 2011, at 4:01 PM, Stuart Tremain wrote:> I just had a though ..... it could be virus checking software that is =causing the problem !>=20> If you disallow the SW from accessing .db files that may solve the =problem. I must check my own configuration !!
Grant Hulbert
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
RE: Tax and ShipCost Problem (1997)
WebCatalog Technical Reference (1997)
Frames and WebCat (1997)
Is the list server working? (1998)
CommandSecurity? (1997)
[WebDNA] Webcatalog on Win XP (2011)
Hiding HTML and breaking the page (1997)
Extended [ConvertChars] (1997)
partial credits (2003)
WebCat2b13MacPlugIn - More limits on [include] (1997)
security (1997)
listfiles-looking for slick solution (1997)
E-mail loop ! (1997)
Remove from list server (1997)
Generating a random image, but avoiding repeated images. (1999)
Can't Update records (1997)
Major Security Hole (1998)
Mass Mail (2000)
not interpreting Q (2001)
[WebDNA] bulk e-mail (2011)