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:
Subtotal Not Calculated on Invoice.html (1998)
PCS Frames (1997)
I'm new be kind (1997)
Multiple catalog databases and showcart (1997)
page redirect in webDNA (1997)
Active Server Code... (1998)
WebCat2 - [include] tags (1997)
Setting up WebCatalog with Retail Pro data (1996)
[sendmail] and [formvariables] (1997)
Emailer or [sendmail] questions ... (1998)
[WebDNA] WebDNA on LiveCD ... (2008)
Grep help (2004)
[WebDNA] HTTP post help (2012)
Custom WebCat Prefs ... (1997)
NT [delete] (1998)
Stopping bad HTML propagation ? (1997)
Nested vs conditional (1997)
Trouble with formula.db (1997)
PCS search results page (1998)
Multiple Attachments with Sendmail (2004)