Re: [WebDNA] online.db deadlock: your current options ...
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106929
interpreted = N
texte = I had installed new Antivirus SW a few months back, and on checking = today I had not excluded .db files or the directory where the db files = are stored. I have changed this setting and will keep an eye on it over the next = week. Hopefully this has solved a problem, it will also speed up the server !! Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 12/07/2011, at 9:29 AM, Grant Hulbert wrote: > 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. >=20 > 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. >=20 > On Jul 11, 2011, at 4:01 PM, Stuart Tremain wrote: >=20 >> 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 !! >=20 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list
. > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us
Associated Messages, from the most recent to the oldest:
I had installed new Antivirus SW a few months back, and on checking = today I had not excluded .db files or the directory where the db files = are stored. I have changed this setting and will keep an eye on it over the next = week. Hopefully this has solved a problem, it will also speed up the server !! Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 12/07/2011, at 9:29 AM, Grant Hulbert wrote: > 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. >=20 > 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. >=20 > On Jul 11, 2011, at 4:01 PM, Stuart Tremain wrote: >=20 >> 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 !! >=20 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us
Stuart Tremain
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:
Still Stumped on ShowNext...HELP! (1997)
RE: NewCart+Search with one click ? (1997)
Unformatted Messages (1998)
Deleting Orders (1997)
WebCommerce: Folder organization ? (1997)
Re1000001: Setting up shop (1997)
any idea (2004)
forms and variables (1998)
converting characters in form (1997)
remove.htm from result (2005)
Anyone using unix? Having problems... (2000)
[addlineitems] (1997)
# of real domains on 1 web server (1997)
Separate SSL Server (1997)
[WebDNA] Serial numbers and pricing for WebDNA 7.0 (2011)
Browser Resolution (1999)
Empty Shopping Carts (1998)
[lookup] is case-sensitive, [lookup] is case sensitive... (2003)
[TCPConnect] Errors (2003)
Location of Browser Info.txt file (1997)