Re: [WebDNA] An unknown error occured // Deadlock avoided
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106923
interpreted = N
texte = > You guys are all missing the point. The guys wants it. No one missed the point. I suggested a solution that will absolutely work, and it will give PigHead the data he wants. When you eliminate the db accesses as I suggested, you also eliminate the deadlock issue. Simple. > That all being said, that code looks like it could be > done with a two lines of code. If the site is so busy that the heavy traffic is causing the deadlock issue, replacing append with replace may not help. In this case the better solution may be to write to a log file rather than to the dbs. Since writing to a log file will absolutely avoid deadlock issues it is arguably a better approach -- especially if your goal is to solve the problem definitively the first time. > I cannot see how you know if someone has gone > offline or not based on the above code. Agreed. So just write to a log file that is formatted as a db and then it can be included in the PigHead's special admin template. Then search for only the hits recorded during the past 5 minutes or one hour or whatever PigHead's particular opinion is about how long people remain on the site after their last hit. > So if you need that simply add a > timestamp to the db and run a different script, I > recommend from a trigger or cron job, and have it remove > anyone that is idle for more than X minutes. My suggestion above does the same thing more easily while avoiding all db accesses, and it is guaranteed to eliminate the deadlock issue without fail. Look, I don't have any problem using dbs (or using replace instead of append) when dbs are actually necessary. But dbs are absolutely not necessary here, so why not avoid them altogether? Then you KNOW you're going to eliminate the problem! Sincerely, Kenneth Grome
Associated Messages, from the most recent to the oldest:
> You guys are all missing the point. The guys wants it. No one missed the point. I suggested a solution that will absolutely work, and it will give PigHead the data he wants. When you eliminate the db accesses as I suggested, you also eliminate the deadlock issue. Simple. > That all being said, that code looks like it could be > done with a two lines of code. If the site is so busy that the heavy traffic is causing the deadlock issue, replacing append with replace may not help. In this case the better solution may be to write to a log file rather than to the dbs. Since writing to a log file will absolutely avoid deadlock issues it is arguably a better approach -- especially if your goal is to solve the problem definitively the first time. > I cannot see how you know if someone has gone > offline or not based on the above code. Agreed. So just write to a log file that is formatted as a db and then it can be included in the PigHead's special admin template. Then search for only the hits recorded during the past 5 minutes or one hour or whatever PigHead's particular opinion is about how long people remain on the site after their last hit. > So if you need that simply add a > timestamp to the db and run a different script, I > recommend from a trigger or cron job, and have it remove > anyone that is idle for more than X minutes. My suggestion above does the same thing more easily while avoiding all db accesses, and it is guaranteed to eliminate the deadlock issue without fail. Look, I don't have any problem using dbs (or using replace instead of append) when dbs are actually necessary. But dbs are absolutely not necessary here, so why not avoid them altogether? Then you KNOW you're going to eliminate the problem! Sincerely, Kenneth Grome
Kenneth Grome
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:
A multi-processor savvy WebCatalog? (1997)
if then else. BUG? (2003)
Sandbox DB permissions (2005)
Includeform Error (2002)
WebCat for Unix?? (1997)
Updating a database once per day - An example (1998)
Nested tags count question (1997)
RE: extended ASCII with middle command (1999)
WebCommerce: Folder organization ? (1997)
setcookie getcookie on the same page (2003)
b12 cannot limit records returned and more. (1997)
Showif, Hideif reverse logic ? (1997)
wierd crashes for multi-sendmails on NT (1997)
Freeze (2003)
User / Pass in TCP connect (2007)
Smith Micro - no competition (2000)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
SQLCONNECT (2005)
Show first 50 characters (2005)
separate by mont (search) (2002)