[WebDNA] 60% failure rate using replace in a loop
This WebDNA talk-list message is from 2010
It keeps the original formatting.
numero = 105610
interpreted = N
texte = 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:55EQX6015:16:55EQX6115:16:55RDR6215:16:55FHS6315:16:55XMO6415:16:56XMO6515:16:56IMG6615:16:56FBF6715:16:56XMO6815:16:57EGR6915:16:58LPG7015:16:58LPG7115:16:58VWG7215:16:58EQX7315:16:58FHS7415:16:59NVR7515:16:59SNA7615:16:59NVRThis is way below the expected performance of this code. Never in my life have I seen WebDNA fail so miserably.The next time the code was run 17 of 45 transactions were processed, for a LESS THAN 40% success rate:11815:20:55LPG11915:20:56LJU12015:20:56LJU12115:20:56EQX12215:20:56FBF12315:20:56NVR12415:20:57FTE12515:20:57NVR12615:20:57PJL12715:20:58IMG12815:20:58EGR12915:20:58FHS13015:20:59IMG13115:20:59PIC13215:20:59EGR13315:20:59EQX13415:20:59LJU... and the next time we're back to 18 out of 45 again.17615:24:55OTL17715:24:55LJU17815:24:55VKW17915:24:55NVR18015:24:56VWG18115:24:56EQX18215:24:56EQX18315:24:56RDR18415:24:56WXO18515:24:58NVR18615:24:58WZC18715:24:58VWG18815:24:58OTL18915:24:58WZC19015:24:58IMG19115:24:59IMG19215:24:59EGR19315:24:59VKWSo basically I can count on WebDNA to fail to record about 60% of the bids my auction simulator is creating. Naturally this makes me wonder how many real bids will fail to be recorded when I run the real auction?:(Sincerely,Kenneth Grome
Associated Messages, from the most recent to the oldest:
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:55EQX6015:16:55EQX6115:16:55RDR6215:16:55FHS6315:16:55XMO6415:16:56XMO6515:16:56IMG6615:16:56FBF6715:16:56XMO6815:16:57EGR6915:16:58LPG7015:16:58LPG7115:16:58VWG7215:16:58EQX7315:16:58FHS7415:16:59NVR7515:16:59SNA7615:16:59NVRThis is way below the expected performance of this code. Never in my life have I seen WebDNA fail so miserably.The next time the code was run 17 of 45 transactions were processed, for a LESS THAN 40% success rate:11815:20:55LPG11915:20:56LJU12015:20:56LJU12115:20:56EQX12215:20:56FBF12315:20:56NVR12415:20:57FTE12515:20:57NVR12615:20:57PJL12715:20:58IMG12815:20:58EGR12915:20:58FHS13015:20:59IMG13115:20:59PIC13215:20:59EGR13315:20:59EQX13415:20:59LJU... and the next time we're back to 18 out of 45 again.17615:24:55OTL17715:24:55LJU17815:24:55VKW17915:24:55NVR18015:24:56VWG18115:24:56EQX18215:24:56EQX18315:24:56RDR18415:24:56WXO18515:24:58NVR18615:24:58WZC18715:24:58VWG18815:24:58OTL18915:24:58WZC19015:24:58IMG19115:24:59IMG19215:24:59EGR19315:24:59VKWSo basically I can count on WebDNA to fail to record about 60% of the bids my auction simulator is creating. Naturally this makes me wonder how many real bids will fail to be recorded when I run the real auction?:(Sincerely,Kenneth Grome
Kenneth Grome
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:
Requiring that certain fields be completed (1997)
taxTotal, grandTotal (1997)
Clean Code: Rules for inserting keyboard returns? (1997)
LinkExchange (1997)
webcat- multiple selection in input field (1997)
search for all (1998)
Running _every_ page through WebCat ? (1997)
Does [Sendmail] create html? (2002)
Fun with dates (1997)
Problem with summary on date / inconsequent webcat behaviour (1998)
problems with 2 tags shakur (1997)
[WebDNA] Encode cookies ONLY via "method=Base64" (2008)
web merchant (2000)
UPS Shipping Primer (2003)
credit card (1997)
WebDNA Partner edition .. (2002)
Trouble with formula.db + more explanation (1997)
webcat- multiple selection in input field (1997)
WebMerchant 1.6 and SHTML (1997)
No shipping systems available? (1998)