Re: Busy WebCatalog
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 32767
interpreted = N
texte = I am experiencing these as well. I am attempting to rewrite bannersleuth andwill also be providing it as opensource. I have a work around, but wouldinstead prefer that WebCatalog function as advertised. Nothing I see hereseems to be strenuous on the server or webcatalog. Shouldn't webcat que itsjobs? Shouldn't each access be seen as a seperate instance and be qued forprocessing. This code hangs the page due to exclusive locks, even with thecode in the spawn. Now this is obviously a bug.Check out this code and tell me why if a single instance of this on a pagewill work fine, but if a multiple instances of this code on a single pagewill cause a the exclusive locks and eventual kill the server.****************** Example Code ********************************
[Search db=Banner_Dbs/ads.db&eqsec[s]datarq=X&eqdefdatarq=ad&UIDsort=1&UIDtype=num&UIDsdir=ra&max=1][FoundItems][text]uuid=[UID][/text][text]r=[showif [referrer]=]Unknown[/showif][URL][referrer][/URL][/text][hideif [image]^.html]
![[location] [location]](Banner_Ads/[url][image][/url])
[/hideif][showif [image]^.html][include Banner_Ads/[url][image][/url]][/showif][text]spid=[sid][/text][/founditems][/Search][spawn][!]spawn this record due to db locking, this calculate the total views etcfor a specific ad.[/!][search db=Banner_Dbs/ads.db&equiddata=[uuid]][founditems][math show=F]nueviews=[NumViews]+1[/math][math show=F]spmaxviews=[showif [maxviews]=]0[/showif][maxviews][/math][text]sptype=[type][/text][/founditems][/search][Replace db=Banner_Dbs/ads.db&eqUIDdatarq=[uuid]]NumViews=[nueviews][showif[sptype]=MV][showif[NueViews]>[spMaxViews]]&Def=expad[/showif][/showif][/Replace][/spawn][spawn][!]spawn this record due to db locking, this calculates specific addplacement, month, day, week hour etc. Placing this in the second spawn didno good either.[/!][search db=Banner_Dbs/logs.db&eqrefdatarq=[r]&eqAYIDdatarq=[date%Y]_[uuid]_[s]][showif [numfound]=0][append db=Banner_Dbs/refloc.db]RID=[cart]&ref=[r][/append][append db=Banner_Dbs/logs.db]SID=[cart]&ref=[r]&sec=[s]&CID=[ClientID]&AYID=[date%Y]_[uuid]_[s]&AYear=[date%Y]&AID=[uuid]&vdate=[Math]{[date]}[/Math]&vtime=[Math]{[time]}[/Math]&DV_[date %j]=1&TV=1&TC=0&MTV_[date %m]=1&WTV_[date %W]=1&HTV_[date %H]=[math show=T]hview+1[/math][loop start=1&end=366][hideif [date%j]=[index]]&DV_[index]=0[/hideif]&DC_[index]=0[/loop][loopstart=0&end=52]&WCT_[Format .2d][index][/format]=0[hideif [date%W]=[index]]&WTV_[Format .2d][index][/format]=0[/hideif][/loop][loop start=1&end=12]&MCT_[Format .2d][index][/format]=0[hideif [date%m]=[index]]&MTV_[Format .2d][index][/format]=0[/hideif][/loop][loopstart=0&end=23]&HCT_[Format .2d][index][/format]=0[hideif [date%H]=[index]]&HTV_[Format .2d][index][/format]=0[/hideif][/loop][/append][/showif][founditems][math show=f]app=0[/math][math show=f]tv1=[TV]+1[/math][mathshow=f]nview=[interpret][DV_[date %j]][/interpret][/math][mathshow=f]mview=[interpret][MTV_[date %m]][/interpret][/math][mathshow=f]wview=[interpret][WTV_[date %W]][/interpret][/math][math show=f]hview=[interpret][HTV_[date %H]][/interpret][/math][Replace db=Banner_Dbs/logs.db&eqSIDdatarq=[sid]]vdate=[Math]{[date]}[/Math]&vtime=[Math]{[time]}[/Math]&TV=[tv1]&DV_[date %j]=[mathshow=T]nview+1[/math]&MTV_[date %m]=[math show=T]mview+1[/math]&WTV_[date%W]=[math show=T]wview+1[/math]&HTV_[date %H]=[Math show=T]hview+1[/math][/replace][/founditems][/search][/spawn][showif [nueviews]\10][commitdatabase Banner_Dbs/ads.db][commitdatabaseBanner_Dbs/logs.db][/showif]******************************** End Code View **************************Robert MinorDirector of Internet Services------------------------------------------------------------Cybermill Communicationshttp://www.cybermill.com http://www.merchantmaker.comProviding Ecommerce and interactive website development andhosting services on Macintosh, Windows NT, Unix, and AS/400.> From: Paul Uttermohlen
> Reply-To: > Date: Tue, 6 Jun 2000 12:15:03> To: > Subject: Re: Busy WebCatalog> > And once a few months ago webstar log file lines (about> an hours worth) were written into the middle of our data obliterating> valuable customer banner ad tracking information.#############################################################This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to To switch to the INDEX mode, E-mail to Send administrative queries to
Associated Messages, from the most recent to the oldest:
I am experiencing these as well. I am attempting to rewrite bannersleuth andwill also be providing it as opensource. I have a work around, but wouldinstead prefer that WebCatalog function as advertised. Nothing I see hereseems to be strenuous on the server or webcatalog. Shouldn't webcat que itsjobs? Shouldn't each access be seen as a seperate instance and be qued forprocessing. This code hangs the page due to exclusive locks, even with thecode in the spawn. Now this is obviously a bug.Check out this code and tell me why if a single instance of this on a pagewill work fine, but if a multiple instances of this code on a single pagewill cause a the exclusive locks and eventual kill the server.****************** Example Code ********************************[Search db=Banner_Dbs/ads.db&eqsec[s]datarq=X&eqdefdatarq=ad&UIDsort=1&UIDtype=num&UIDsdir=ra&max=1][founditems][text]uuid=[UID][/text][text]r=[showif [referrer]=]Unknown[/showif][url][referrer][/URL][/text][hideif [image]^.html][url][uid][/url]&r=[url][referrer][/URL]&d=[date %Y]_[uuid]_[s]target=_new>
[url][image][/url] height=[imgh] width=[imgw]border=[border] alt=[location] title=[location]>[/hideif][showif [image]^.html][include Banner_Ads/[url][image][/url]][/showif][text]spid=[sid][/text][/founditems][/Search][spawn][!]spawn this record due to db locking, this calculate the total views etcfor a specific ad.[/!][search db=Banner_Dbs/ads.db&equiddata=[uuid]][founditems][math show=F]nueviews=[NumViews]+1[/math][math show=F]spmaxviews=[showif [maxviews]=]0[/showif][maxviews][/math][text]sptype=[type][/text][/founditems][/search][Replace db=Banner_Dbs/ads.db&eqUIDdatarq=[uuid]]NumViews=[nueviews][showif[sptype]=MV][showif[NueViews]>[spMaxViews]]&Def=expad[/showif][/showif][/Replace][/spawn][spawn][!]spawn this record due to db locking, this calculates specific addplacement, month, day, week hour etc. Placing this in the second spawn didno good either.[/!][search db=Banner_Dbs/logs.db&eqrefdatarq=[r]&eqAYIDdatarq=[date%Y]_[uuid]_[s]][showif [numfound]=0][append db=Banner_Dbs/refloc.db]RID=[cart]&ref=[r][/append][append db=Banner_Dbs/logs.db]SID=[cart]&ref=[r]&sec=[s]&CID=[ClientID]&AYID=[date%Y]_[uuid]_[s]&AYear=[date%Y]&AID=[uuid]&vdate=[math]{[date]}[/Math]&vtime=[math]{[time]}[/Math]&DV_[date %j]=1&TV=1&TC=0&MTV_[date %m]=1&WTV_[date %W]=1&HTV_[date %H]=[math show=T]hview+1[/math][loop start=1&end=366][hideif [date%j]=[index]]&DV_[index]=0[/hideif]&DC_[index]=0[/loop][loopstart=0&end=52]&WCT_[Format .2d][index][/format]=0[hideif [date%W]=[index]]&WTV_[Format .2d][index][/format]=0[/hideif][/loop][loop start=1&end=12]&MCT_[Format .2d][index][/format]=0[hideif [date%m]=[index]]&MTV_[Format .2d][index][/format]=0[/hideif][/loop][loopstart=0&end=23]&HCT_[Format .2d][index][/format]=0[hideif [date%H]=[index]]&HTV_[Format .2d][index][/format]=0[/hideif][/loop][/append][/showif][founditems][math show=f]app=0[/math][math show=f]tv1=[TV]+1[/math][mathshow=f]nview=[interpret][DV_[date %j]][/interpret][/math][mathshow=f]mview=[interpret][MTV_[date %m]][/interpret][/math][mathshow=f]wview=[interpret][WTV_[date %W]][/interpret][/math][math show=f]hview=[interpret][HTV_[date %H]][/interpret][/math][Replace db=Banner_Dbs/logs.db&eqSIDdatarq=[sid]]vdate=[math]{[date]}[/Math]&vtime=[Math]{[time]}[/Math]&TV=[tv1]&DV_[date %j]=[mathshow=T]nview+1[/math]&MTV_[date %m]=[math show=T]mview+1[/math]&WTV_[date%W]=[math show=T]wview+1[/math]&HTV_[date %H]=[Math show=T]hview+1[/math][/replace][/founditems][/search][/spawn][showif [nueviews]\10][commitdatabase Banner_Dbs/ads.db][commitdatabaseBanner_Dbs/logs.db][/showif]******************************** End Code View **************************Robert MinorDirector of Internet Services------------------------------------------------------------Cybermill Communicationshttp://www.cybermill.com http://www.merchantmaker.comProviding Ecommerce and interactive website development andhosting services on Macintosh, Windows NT, Unix, and AS/400.> From: Paul Uttermohlen > Reply-To: > Date: Tue, 6 Jun 2000 12:15:03> To: > Subject: Re: Busy WebCatalog> > And once a few months ago webstar log file lines (about> an hours worth) were written into the middle of our data obliterating> valuable customer banner ad tracking information.#############################################################This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to To switch to the INDEX mode, E-mail to Send administrative queries to
Bob Minor
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:
A new bug? (1999)
searchable list archive (1997)
Purchase Plugin Missing (1996)
Looping Search (2006)
SQL (2003)
PCS Frames (1997)
[WebDNA] Upgrade 4.5.1 to 6.0a (2009)
[cart] Taxrate - seriously .. (2002)
Exporting from Excel (1998)
[OT] OSX (unix) favorite text editor. (2002)
ShowNext (1997)
[WebDNA] [announce] WebDNA Site and Store (2008)
RE: Automatic Forwarding using WebCat (1997)
Was: URGENT now: Another Bug (2002)
Separate SSL Server (1997)
Conveting Characters to Graphics (1997)
Too many webcat comments. [WAS- Large founditems loops] (2000)
[OT] Brain Switching (2004)
Caching [include] files ... (1997)
test for John (1999)