Re: [WebDNA] An unknown error occured // Deadlock avoided
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106906
interpreted = N
texte = It is indeed a logging database, it is used to count how many online user=sthere are at any given time. If someone else has a better way of doingthis, then by all means please let me know.It is basically a visitor counter so the guy that is in charge can see ho=wmany users are currently viewing the site./TommyOn Mon, 11 Jul 2011 06:56:18 -0700, Dan Strong
wrote:> Tommy,>=20> 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==20> appears to me to be a "traffic log" database that records all hits to a==20> (every?) page. This kind of database can obviously get some serious=20> action on a busy server and the database can also grow pretty quickly.=20> Ultimately though, the database is redundant and unnecessary since the=20> web server software (IIS I assume... Windows, right?) does this sort of==20> logging usually by default.>=20> If I am correct (and I apologize if I'm not... like I said, I didn't=20> read everything), if it was my problem to deal with I'd completely=20> disable/disconnect this database, if only to troubleshoot, but=20> ultimately to give the server some breathing room, especially if it's a==20> busy one.>=20> Hope this helps.> -Dan>=20> On 7/11/2011 1:03 AM, tommy@enkelthed.dk wrote:>> [search db=3D[path]../../database/online.db&eqDB_IPdatarq=3D[IPAddress=]]>> [showIf [numFound]=3D0]>> [append>>db=3D[path]../../database/online.db]DB_IP=3D[IPAddress]&DB_DATO=3D[DATE]&=DB_TID=3D[time]&DB_URL=3D[url][ThisURL]?a=3Db[FormVariables][hideIf>>[name]=3Dtemplate]&[name]=3D[value][/hideIf][/FormVariables][/url]&DB_KUN=DEID=3D[kunde]&DB_BROWSER=3D[url][browser][/url]&DB_URL_REF=3D[url][REFER=RER][/url][/append]>> [search db=3D[path]../../database/counter.db&eqDB_DATOdata=3D[date>> %Y/%m/%d]]>> [showIf [numFound]<1]>> [append db=3D[path]../../database/counter.db]DB_DATO=3D[date>> %Y/%m/%d]&DB_ANTAL=3D1[/append]>> [/showIf]>> [showIf [numFound]>0]>>>>[replacefoundItems]DB_ANTAL=3D[math][DB_ANTAL]+1[/math][/replacefoundIte=ms]>> [/showIf]>> [/search]>> [/showIf]>> [showIf [numFound]=3D1]>> [replace>>db=3D[path]../../database/online.db&eqDB_IPdatarq=3D[IPAddress]]DB_DATO=3D=[DATE]&DB_TID=3D[time]&DB_URL=3D[url][ThisURL]?a=3Db[FormVariables][hideI=f>>[name]=3Dtemplate]&[name]=3D[value][/hideIf][/FormVariables][/url]&DB_KUN=DEID=3D[kunde][/replace]>> [/showIf]>> [/search]
Associated Messages, from the most recent to the oldest:
It is indeed a logging database, it is used to count how many online user=sthere are at any given time. If someone else has a better way of doingthis, then by all means please let me know.It is basically a visitor counter so the guy that is in charge can see ho=wmany users are currently viewing the site./TommyOn Mon, 11 Jul 2011 06:56:18 -0700, Dan Strong wrote:> Tommy,>=20> 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==20> appears to me to be a "traffic log" database that records all hits to a==20> (every?) page. This kind of database can obviously get some serious=20> action on a busy server and the database can also grow pretty quickly.=20> Ultimately though, the database is redundant and unnecessary since the=20> web server software (IIS I assume... Windows, right?) does this sort of==20> logging usually by default.>=20> If I am correct (and I apologize if I'm not... like I said, I didn't=20> read everything), if it was my problem to deal with I'd completely=20> disable/disconnect this database, if only to troubleshoot, but=20> ultimately to give the server some breathing room, especially if it's a==20> busy one.>=20> Hope this helps.> -Dan>=20> On 7/11/2011 1:03 AM, tommy@enkelthed.dk wrote:>> [search db=3D[path]../../database/online.db&eqDB_IPdatarq=3D[IPAddress=]]>> [showIf [numFound]=3D0]>> [append>>db=3D[path]../../database/online.db]DB_IP=3D[ipaddress]&DB_DATO=3D[date]&=DB_TID=3D[time]&DB_URL=3D[url][thisurl]?a=3Db[formvariables][hideIf>>[name]=3Dtemplate]&[name]=3D[value][/hideIf][/FormVariables][/url]&DB_KUN=DEID=3D[kunde]&DB_BROWSER=3D[url][browser][/url]&DB_URL_REF=3D[url][REFER=RER][/url][/append]>> [search db=3D[path]../../database/counter.db&eqDB_DATOdata=3D[date>> %Y/%m/%d]]>> [showIf [numFound]<1]>> [append db=3D[path]../../database/counter.db]DB_DATO=3D[date>> %Y/%m/%d]&DB_ANTAL=3D1[/append]>> [/showIf]>> [showIf [numFound]>0]>>>>[replacefounditems]DB_ANTAL=3D[math][DB_ANTAL]+1[/math][/replacefoundIte=ms]>> [/showIf]>> [/search]>> [/showIf]>> [showIf [numFound]=3D1]>> [replace>>db=3D[path]../../database/online.db&eqDB_IPdatarq=3D[ipaddress]]DB_DATO=3D=[date]&DB_TID=3D[time]&DB_URL=3D[url][thisurl]?a=3Db[formvariables][hideI=f>>[name]=3Dtemplate]&[name]=3D[value][/hideIf][/FormVariables][/url]&DB_KUN=DEID=3D[kunde][/replace]>> [/showIf]>> [/search]
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:
Updating product information (2002)
catagories (1997)
WebMerchant and Mac Auth Hub Help Please (1999)
Next (1997)
Date Sorting (1997)
WebDNA Developer Resource Center (2002)
Suggestions (1998)
credit card (1997)
aaron kant add (2.x) (2000)
Searching multiple fields (1997)
OT: Unix question (2003)
[Sum] function? (1997)
emailer setup (1997)
UPS (2003)
Banner DNA (1997)
Security Hole - NetCloak Update (1998)
off topic
CommandSecurity? (1997)
Prices coming up 0.00 (2001)
Looking For WebCatalog Migration Assistance (2003)