Re: [WebDNA] 60% failure rate using replace in a loop

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 105611
interpreted = N
texte = does it help if you commit to disk upon each attempted [replace]? Or if you spawn/chunk clumps of the [replace]s? Or if you force a slight delay with [waitforfile] in between clumps? Of course webdna will need some time to recover .. and the waiting may just delay that recovery.. but it may be just enough to provide the wiggle room until a natural break in the activity comes along. Can you post your simulator code so we can see if any more ideas come up? What if you switch to writing to a SQL db with [SQL...] contexts? Would that help? (maybe at that intensity of activity per second the SQL format would perform better. I have no idea.. but it seems worth trying to see what you are up against. -G On Jul 18, 2010, at 4:46 PM, Kenneth Grome wrote: > Webdna is failing (miserably) to replace the data it is supposed to > replace in one of my db's. I'm running some code that's supposed to > create 9 new 'simulated' bids per second during a 5-second period > every 4 minutes, but instead WebDNA seems to "max out" at 18 bids -- > a pathetic 40% success rate. > > My results are repeatable. I only get 17-18 records modified each > time this code runs. The remaining 27-28 bids are simply not > written -- which means they are apparently 'lost forever'. > > There should be 9 records shown here for each of the 5 seconds in > this list, but I see only 18 records instead of the expected 45 -- a > 60% failure rate: > > 5915:16:55EQX > 6015:16:55EQX > 6115:16:55RDR > 6215:16:55FHS > 6315:16:55XMO > 6415:16:56XMO > 6515:16:56IMG > 6615:16:56FBF > 6715:16:56XMO > 6815:16:57EGR > 6915:16:58LPG > 7015:16:58LPG > 7115:16:58VWG > 7215:16:58EQX > 7315:16:58FHS > 7415:16:59NVR > 7515:16:59SNA > 7615:16:59NVR > [snip] ------------ Govinda govinda.webdnatalk@gmail.com Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] 60% failure rate using replace in a loop (Govinda 2010)
  2. [WebDNA] 60% failure rate using replace in a loop (Kenneth Grome 2010)
does it help if you commit to disk upon each attempted [replace]? Or if you spawn/chunk clumps of the [replace]s? Or if you force a slight delay with [waitforfile] in between clumps? Of course webdna will need some time to recover .. and the waiting may just delay that recovery.. but it may be just enough to provide the wiggle room until a natural break in the activity comes along. Can you post your simulator code so we can see if any more ideas come up? What if you switch to writing to a SQL db with [SQL...] contexts? Would that help? (maybe at that intensity of activity per second the SQL format would perform better. I have no idea.. but it seems worth trying to see what you are up against. -G On Jul 18, 2010, at 4:46 PM, Kenneth Grome wrote: > Webdna is failing (miserably) to replace the data it is supposed to > replace in one of my db's. I'm running some code that's supposed to > create 9 new 'simulated' bids per second during a 5-second period > every 4 minutes, but instead WebDNA seems to "max out" at 18 bids -- > a pathetic 40% success rate. > > My results are repeatable. I only get 17-18 records modified each > time this code runs. The remaining 27-28 bids are simply not > written -- which means they are apparently 'lost forever'. > > There should be 9 records shown here for each of the 5 seconds in > this list, but I see only 18 records instead of the expected 45 -- a > 60% failure rate: > > 5915:16:55EQX > 6015:16:55EQX > 6115:16:55RDR > 6215:16:55FHS > 6315:16:55XMO > 6415:16:56XMO > 6515:16:56IMG > 6615:16:56FBF > 6715:16:56XMO > 6815:16:57EGR > 6915:16:58LPG > 7015:16:58LPG > 7115:16:58VWG > 7215:16:58EQX > 7315:16:58FHS > 7415:16:59NVR > 7515:16:59SNA > 7615:16:59NVR > [snip] ------------ Govinda govinda.webdnatalk@gmail.com Govinda

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:

[ShowNext] feature in 2.0 (1997) how to check for no value while using [URL] to prevent cr (1999) SQL Support in 6.0 (2004) On a related topic (2006) Return records from another (1997) [WebDNA] [returnraw] on different platforms. (2008) Rendering out a page (1997) ATTN:SMITH MICRO (2001) What generates Problem With Your Order email? (2000) IE Cache Problems... (1999) Wanted: More Math Functions (or, Can You Solve This?) (1997) Applescript, WebDNA, and PDF (1997) Sort Order on a page search (1997) [WebDNA] WebDNA restart script (2015) Re:Formulas.db / Quantity Discount problem (1998) PCS Frames (1997) Modifying order output (1997) WCS Newbie question (1997) WebCatalog2 Feature Feedback (1996) Dark Horse Comics success story (1997)