Re: [WebDNA] An unknown error occured // Deadlock avoided
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106907
interpreted = N
texte = Is there any reason why he doesn't use the native IIS log files? -Dan On 7/11/2011 6:59 AM, tommy@enkelthed.dk wrote: > It is indeed a logging database, it is used to count how many online users > there are at any given time. If someone else has a better way of doing > this, then by all means please let me know. > > It is basically a visitor counter so the guy that is in charge can see how > many users are currently viewing the site. > > /Tommy > On Mon, 11 Jul 2011 06:56:18 -0700, Dan Strong
> wrote: >> Tommy, >> >> I haven't read through every single thing and don't claim to know what's >> going on with your server, but a quick glance at the posted code and it >> appears to me to be a "traffic log" database that records all hits to a >> (every?) page. This kind of database can obviously get some serious >> action on a busy server and the database can also grow pretty quickly. >> Ultimately though, the database is redundant and unnecessary since the >> web server software (IIS I assume... Windows, right?) does this sort of >> logging usually by default. >> >> If I am correct (and I apologize if I'm not... like I said, I didn't >> read everything), if it was my problem to deal with I'd completely >> disable/disconnect this database, if only to troubleshoot, but >> ultimately to give the server some breathing room, especially if it's a >> busy one. >> >> Hope this helps. >> -Dan >> >> On 7/11/2011 1:03 AM, tommy@enkelthed.dk wrote: >>> [search db=[path]../../database/online.db&eqDB_IPdatarq=[IPAddress]] >>> [showIf [numFound]=0] >>> [append >>> > db=[path]../../database/online.db]DB_IP=[IPAddress]&DB_DATO=[DATE]&DB_TID=[time]&DB_URL=[url][ThisURL]?a=b[FormVariables][hideIf > [name]=template]&[name]=[value][/hideIf][/FormVariables][/url]&DB_KUNDEID=[kunde]&DB_BROWSER=[url][browser][/url]&DB_URL_REF=[url][REFERRER][/url][/append] >>> [search db=[path]../../database/counter.db&eqDB_DATOdata=[date >>> %Y/%m/%d]] >>> [showIf [numFound]<1] >>> [append db=[path]../../database/counter.db]DB_DATO=[date >>> %Y/%m/%d]&DB_ANTAL=1[/append] >>> [/showIf] >>> [showIf [numFound]>0] >>> >>> > [replacefoundItems]DB_ANTAL=[math][DB_ANTAL]+1[/math][/replacefoundItems] >>> [/showIf] >>> [/search] >>> [/showIf] >>> [showIf [numFound]=1] >>> [replace >>> > db=[path]../../database/online.db&eqDB_IPdatarq=[IPAddress]]DB_DATO=[DATE]&DB_TID=[time]&DB_URL=[url][ThisURL]?a=b[FormVariables][hideIf > [name]=template]&[name]=[value][/hideIf][/FormVariables][/url]&DB_KUNDEID=[kunde][/replace] >>> [/showIf] >>> [/search] > --------------------------------------------------------- > 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:
Is there any reason why he doesn't use the native IIS log files? -Dan On 7/11/2011 6:59 AM, tommy@enkelthed.dk wrote: > It is indeed a logging database, it is used to count how many online users > there are at any given time. If someone else has a better way of doing > this, then by all means please let me know. > > It is basically a visitor counter so the guy that is in charge can see how > many users are currently viewing the site. > > /Tommy > On Mon, 11 Jul 2011 06:56:18 -0700, Dan Strong > wrote: >> Tommy, >> >> I haven't read through every single thing and don't claim to know what's >> going on with your server, but a quick glance at the posted code and it >> appears to me to be a "traffic log" database that records all hits to a >> (every?) page. This kind of database can obviously get some serious >> action on a busy server and the database can also grow pretty quickly. >> Ultimately though, the database is redundant and unnecessary since the >> web server software (IIS I assume... Windows, right?) does this sort of >> logging usually by default. >> >> If I am correct (and I apologize if I'm not... like I said, I didn't >> read everything), if it was my problem to deal with I'd completely >> disable/disconnect this database, if only to troubleshoot, but >> ultimately to give the server some breathing room, especially if it's a >> busy one. >> >> Hope this helps. >> -Dan >> >> On 7/11/2011 1:03 AM, tommy@enkelthed.dk wrote: >>> [search db=[path]../../database/online.db&eqDB_IPdatarq=[ipaddress]] >>> [showIf [numFound]=0] >>> [append >>> > db=[path]../../database/online.db]DB_IP=[ipaddress]&DB_DATO=[date]&DB_TID=[time]&DB_URL=[url][thisurl]?a=b[formvariables][hideIf > [name]=template]&[name]=[value][/hideIf][/FormVariables][/url]&DB_KUNDEID=[kunde]&DB_BROWSER=[url][browser][/url]&DB_URL_REF=[url][referrer][/url][/append] >>> [search db=[path]../../database/counter.db&eqDB_DATOdata=[date >>> %Y/%m/%d]] >>> [showIf [numFound]<1] >>> [append db=[path]../../database/counter.db]DB_DATO=[date >>> %Y/%m/%d]&DB_ANTAL=1[/append] >>> [/showIf] >>> [showIf [numFound]>0] >>> >>> > [replacefounditems]DB_ANTAL=[math][DB_ANTAL]+1[/math][/replacefoundItems] >>> [/showIf] >>> [/search] >>> [/showIf] >>> [showIf [numFound]=1] >>> [replace >>> > db=[path]../../database/online.db&eqDB_IPdatarq=[ipaddress]]DB_DATO=[date]&DB_TID=[time]&DB_URL=[url][thisurl]?a=b[formvariables][hideIf > [name]=template]&[name]=[value][/hideIf][/FormVariables][/url]&DB_KUNDEID=[kunde][/replace] >>> [/showIf] >>> [/search] > --------------------------------------------------------- > 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
Dan Strong
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:
acrobat -> wc (1998)
Quick ShowIf question (1997)
Weird error/limit - something amiss? (1997)
emailer on Windows Beta 18 (1997)
help needed w/ search params (1998)
Running _every_ page through WebCat ? (1997)
Re:Help name our technology! (1997)
RequiredFields template (1997)
[index] (1997)
Nesting FoundItem Context (1997)
Google Web Accelerator (2005)
HTML authentication HTML page (1999)
Num Sort Descending (2004)
Protect (1997)
Total found of each unique field (2003)
Opinion: [input] should be called [output] ... (1997)
(1997)
Email Formatting (2001)
Showif with an or (2003)
multi-paragraph fields (1997)