What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

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 and will also be providing it as opensource. I have a work around, but would instead prefer that WebCatalog function as advertised. Nothing I see here seems to be strenuous on the server or webcatalog. Shouldn't webcat que its jobs? Shouldn't each access be seen as a seperate instance and be qued for processing. This code hangs the page due to exclusive locks, even with the code 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 page will work fine, but if a multiple instances of this code on a single page will 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&U IDsdir=ra&max=1] [FoundItems] [text]uuid=[UID][/text] [text]r=[showif [referrer]=]Unknown[/showif][URL][referrer][/URL][/text] [hideif [image]^.html] [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 etc for 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 add placement, month, day, week hour etc. Placing this in the second spawn did no 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_[d ate %j]=1&TV=1&TC=0&MTV_[date %m]=1&WTV_[date %W]=1&HTV_[date %H]=[ma th show=T]hview+1[/math][loop start=1&end=366][hideif [date %j]=[index]]&DV_[index]=0[/hideif]&DC_[index]=0[/loop][loop start=0&end=52]&WCT_[Format .2d][index][/format]=0[hideif [date %W]=[index]]&WTV_[Format .2d][index][/format]=0[/hideif][/loop][loop st art=1&end=12]&MCT_[Format .2d][index][/format]=0[hideif [date %m]=[index]]&MTV_[Format .2d][index][/format]=0[/hideif][/loop][loop start=0&end=23]&HCT_[Format .2d][index][/format]=0[hideif [date %H]=[index]]&HTV_[Format .2d][index][/format]=0[/hideif][/lo op][/append] [/showif] [founditems] [math show=f]app=0[/math][math show=f]tv1=[TV]+1[/math][math show=f]nview=[interpret][DV_[date %j]][/interpret][/math][math show=f]mview=[interpret][MTV_[date %m]][/interpret][/math][math show=f]wview=[interpret][WTV_[date %W]][/interpret][/math][math sho w=f]hview=[interpret][HTV_[date %H]][/interpret][/math] [Replace db=Banner_Dbs/logs.db&eqSIDdatarq=[sid]]vdate=[Math]{[date]}[/Math]&vtime=[M ath]{[time]}[/Math]&TV=[tv1]&DV_[date %j]=[math show=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]=[M ath show=T]hview+1[/math][/replace] [/founditems] [/search] [/spawn][showif [nueviews]\10][commitdatabase Banner_Dbs/ads.db][commitdatabase Banner_Dbs/logs.db][/showif]******************************** End Code View **************************Robert Minor Director of Internet Services ------------------------------------------------------------ Cybermill Communications http://www.cybermill.com http://www.merchantmaker.comProviding Ecommerce and interactive website development and hosting 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:

    
  1. Re: Busy WebCatalog (Grant Hulbert 2000)
  2. Re: Busy WebCatalog (John Butler 2000)
  3. Re: Busy WebCatalog (Wendell Kozak 2000)
  4. Re: Busy WebCatalog (Paul Uttermohlen 2000)
  5. Re: Busy WebCatalog (Bob Minor 2000)
  6. Re: Busy WebCatalog (Grant Hulbert 2000)
  7. Re: Busy WebCatalog (Michael O Shea 2000)
  8. Re: Busy WebCatalog (Grant Hulbert 2000)
  9. Re: Busy WebCatalog (Bob Minor 2000)
  10. Re: Busy WebCatalog (Paul Uttermohlen 2000)
  11. Re: Busy WebCatalog (Michael O Shea 2000)
I am experiencing these as well. I am attempting to rewrite bannersleuth and will also be providing it as opensource. I have a work around, but would instead prefer that WebCatalog function as advertised. Nothing I see here seems to be strenuous on the server or webcatalog. Shouldn't webcat que its jobs? Shouldn't each access be seen as a seperate instance and be qued for processing. This code hangs the page due to exclusive locks, even with the code 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 page will work fine, but if a multiple instances of this code on a single page will 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&U IDsdir=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 etc for 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 add placement, month, day, week hour etc. Placing this in the second spawn did no 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_[d ate %j]=1&TV=1&TC=0&MTV_[date %m]=1&WTV_[date %W]=1&HTV_[date %H]=[ma th show=T]hview+1[/math][loop start=1&end=366][hideif [date %j]=[index]]&DV_[index]=0[/hideif]&DC_[index]=0[/loop][loop start=0&end=52]&WCT_[Format .2d][index][/format]=0[hideif [date %W]=[index]]&WTV_[Format .2d][index][/format]=0[/hideif][/loop][loop st art=1&end=12]&MCT_[Format .2d][index][/format]=0[hideif [date %m]=[index]]&MTV_[Format .2d][index][/format]=0[/hideif][/loop][loop start=0&end=23]&HCT_[Format .2d][index][/format]=0[hideif [date %H]=[index]]&HTV_[Format .2d][index][/format]=0[/hideif][/lo op][/append] [/showif] [founditems] [math show=f]app=0[/math][math show=f]tv1=[TV]+1[/math][math show=f]nview=[interpret][DV_[date %j]][/interpret][/math][math show=f]mview=[interpret][MTV_[date %m]][/interpret][/math][math show=f]wview=[interpret][WTV_[date %W]][/interpret][/math][math sho w=f]hview=[interpret][HTV_[date %H]][/interpret][/math] [Replace db=Banner_Dbs/logs.db&eqSIDdatarq=[sid]]vdate=[math]{[date]}[/Math]&vtime=[M ath]{[time]}[/Math]&TV=[tv1]&DV_[date %j]=[math show=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]=[M ath show=T]hview+1[/math][/replace] [/founditems] [/search] [/spawn][showif [nueviews]\10][commitdatabase Banner_Dbs/ads.db][commitdatabase Banner_Dbs/logs.db][/showif]******************************** End Code View **************************Robert Minor Director of Internet Services ------------------------------------------------------------ Cybermill Communications http://www.cybermill.com http://www.merchantmaker.comProviding Ecommerce and interactive website development and hosting 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)