Re: [WebDNA] An unknown error occured // Deadlock avoided
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106912
interpreted = N
texte = Does he want/need to know how many users are on the site in real time or after the fact? If after the fact there are plenty of ways, of course to handle this, many not involving WebDNA at all... Google Analytics, log-file analyzers, etc.) -Dan On 7/11/2011 7:07 AM, tommy@enkelthed.dk wrote: > I have no idea, the original implementor designed this counter for him to > use, so he could always see how many are online. I am guessing its because > this counter is integrated into webdna, where as the IIS logging files > would have to be processed some other way. I am not sure. > > I supose I could do something about counting the this unique IP's in the > loggin files instead. > > /Tommy > On Mon, 11 Jul 2011 07:02:19 -0700, Dan Strong
> wrote: >> 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 >> --------------------------------------------------------- >> 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 > --------------------------------------------------------- > 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:
Does he want/need to know how many users are on the site in real time or after the fact? If after the fact there are plenty of ways, of course to handle this, many not involving WebDNA at all... Google Analytics, log-file analyzers, etc.) -Dan On 7/11/2011 7:07 AM, tommy@enkelthed.dk wrote: > I have no idea, the original implementor designed this counter for him to > use, so he could always see how many are online. I am guessing its because > this counter is integrated into webdna, where as the IIS logging files > would have to be processed some other way. I am not sure. > > I supose I could do something about counting the this unique IP's in the > loggin files instead. > > /Tommy > On Mon, 11 Jul 2011 07:02:19 -0700, Dan Strong > wrote: >> 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 >> --------------------------------------------------------- >> 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 > --------------------------------------------------------- > 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:
Re:One more time (1997)
WebCatalog can't find database (1997)
Google Problem (2003)
EIMS Problems (1997)
Mac 2.1b2 speed (1997)
Absolute path (2003)
insecuretextvars preference doesn't work (2000)
(2002)
E-mail Attachments (1997)
It finally happened ... (2003)
Thanks Grant (1997)
SKU lookup (1997)
database problem (2003)
SQLCONNECT (2005)
Some Questions (1997)
[OT] - Block Traffic to DevBox (2003)
ImageMagick (2005)
Sort Order on a page search (1997)
copyfile (2003)
Running _every_ page through WebCat ? (1997)