Re: [WebDNA] An unknown error occured // Deadlock avoided
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106924
interpreted = N
texte = Ken, I see you started another thread with the actual code to discuss it. Thanks for that. This thread has grown too long and it my personal opinion is a bit to fractured for any real use. I never meant to get into this discussion to start with, but felt I had to say something. Which I have. I am removing myself from this thread. Best of luck. On Mon, Jul 11, 2011 at 8:48 AM, Kenneth Grome
wrote: >> 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. =A0Simple. > > >> 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. =A0Since 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. =A0Then 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. =A0But dbs > are absolutely not necessary here, so why not avoid them > altogether? =A0Then you KNOW you're going to eliminate the > problem! > > Sincerely, > Kenneth Grome > --------------------------------------------------------- > 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:
Ken, I see you started another thread with the actual code to discuss it. Thanks for that. This thread has grown too long and it my personal opinion is a bit to fractured for any real use. I never meant to get into this discussion to start with, but felt I had to say something. Which I have. I am removing myself from this thread. Best of luck. On Mon, Jul 11, 2011 at 8:48 AM, Kenneth Grome wrote: >> 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. =A0Simple. > > >> 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. =A0Since 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. =A0Then 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. =A0But dbs > are absolutely not necessary here, so why not avoid them > altogether? =A0Then you KNOW you're going to eliminate the > problem! > > Sincerely, > Kenneth Grome > --------------------------------------------------------- > 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 >
Ronald Kirkland
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:
Bugs? What Bugs? was:Spawning Holdup? (2000)
PSC recommends what date format yr 2000??? (1997)
Getting Total Quantity (1997)
Max Record length (1997)
Moment of Thanks (1997)
Upcoming 2.1 Release and PCS Committment (1997)
Installing on IIS 5.1 Windows XP Pro - Username/Password (2006)
Multiple fields on 1 input (1997)
Attn: Bug in GeneralStore example b15 (1997)
[WebDNA] WebDNA restart script (2015)
Search results templates (1996)
Message Board (again:-) (2000)
creating writefile data from a nested search (1997)
[ShowNext] feature in 2.0 (1997)
Problems appending to database (1997)
Does webcatalog recognise NULL values? (1998)
[tcpconnect] doing nothing- SM any help here??? (2001)
WebCat Redundancy (2000)
Sense/Disallow HTML tags during $Append (1997)
RE: [sendmail]- bcc? (1998)