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?-DanOn 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?-DanOn 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:
ExpireDate Zero or Greater than Today (2006)
Starting WebCat under linux (2000)
[WriteFile] problems (1997)
Robert Minor duplicate mail (1997)
notification solutions (1997)
Javascript and Search Results (1998)
XML Woes (2004)
Scoping rules in WebDNA 4.0 (2000)
One more try (1997)
Setting expiration dates for cookies (2000)
Help name our technology! I found it (1997)
Summary search -- speed (1997)
pc (1997)
[include ...] behavior (1997)
URGENT: WebDNA Server Not Running (2003)
[WebDNA] can webdna set the email header (w/[sendmail]) (2012)
webcat- multiple selection in input field (1997)
(2004)
RE: ShowNext Command (1997)
Searching multiple fields from one form field (1997)