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

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 105620
interpreted = N
texte = BTW, we fixed the small bug when the [math] variable name includes a = number ([math]thetest3=3D43[/math]) and we added the new requested tag = [thirurlplusget] so the [thisurl] tag will produce this: /x/y/z/index.dna and the [thirurlplusget] tag will produce this: /x/y/z/index.dna?a=3Db&c=3Dd We are working on the [append] tag that writes to disk and should not. = This behaviour has obviously been previously added to prevent database = loss of data in case of crash, but we think the Administration = configuration that says "Automatically commit databases to disk after = modification", the [closedatabase] tag and the [commitdatabase] provide = security enough. - chris On Jul 19, 2010, at 8:23, Kenneth Grome wrote: >> Ken, i am not sure if you are using [replace] or=20 >> [replacefounditems]. Do not forget [replacefounditems]=20 >> is much faster than the old technique of nesting a [replace]=20 >> context inside a [founditems] context. >=20 > I tried using replacefounditems but that wasn't working in some (but = not all) of my code, so I switched the broken sections to replace -- and = the code that wasn't working before suddenly started working.=20 >=20 > This made me think that maybe there's a bug in replacefounditems. I = was going to report it but when I changed my code from replacefounditems = to replace I over-wrote the failing replacefounditems code and I didn't = have the time to go back and re-write it in order to post to the list = for a confirmation of the problem/bug. >=20 > BTW, last night I streamlined the "replace in a loop" code that was = taking 10-15 seconds to replace 45 db records. I ended up shaving 1-2 = seconds off the elapsedtime. That's not nearly enough of an improvement = for what I need to do -- the response time was still way too slow -- so = I had to rewrite everything anyways, but at least I got it to run a = little bit faster. >=20 > If I can find the time to test replacefounditems again this week I = will give it another try. If I have problems again maybe I will think = far enough ahead to save the problematic code and post it to the list = this time around. >=20 > Sincerely, > Kenneth Grome >=20 >=20 >=20 > --------------------------------------------------------- > 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:

    
  1. Re: [WebDNA] CORRECTION: 60% failure rate using replace in a loop (christophe.billiottet@webdna.us 2010)
  2. Re: [WebDNA] CORRECTION: 60% failure rate using replace in a loop (Kenneth Grome 2010)
  3. Re: [WebDNA] CORRECTION: 60% failure rate using replace in a loop (Kenneth Grome 2010)
  4. Re: [WebDNA] CORRECTION: 60% failure rate using replace in a loop (christophe.billiottet@webdna.us 2010)
  5. Re: [WebDNA] CORRECTION: 60% failure rate using replace in a loop (Kenneth Grome 2010)
  6. Re: [WebDNA] CORRECTION: 60% failure rate using replace in a loop (Kenneth Grome 2010)
  7. Re: [WebDNA] CORRECTION: 60% failure rate using replace in a loop (christophe.billiottet@webdna.us 2010)
  8. Re: [WebDNA] CORRECTION: 60% failure rate using replace in a loop (Kenneth Grome 2010)
  9. Re: [WebDNA] CORRECTION: 60% failure rate using replace in a loop (christophe.billiottet@webdna.us 2010)
  10. Re: [WebDNA] CORRECTION: 60% failure rate using replace in a loop (Kenneth Grome 2010)
  11. Re: [WebDNA] CORRECTION: 60% failure rate using replace in a loop (christophe.billiottet@webdna.us 2010)
  12. Re: [WebDNA] CORRECTION: 60% failure rate using replace in a loop (Kenneth Grome 2010)
  13. Re: [WebDNA] CORRECTION: 60% failure rate using replace in a loop (christophe.billiottet@webdna.us 2010)
  14. [WebDNA] CORRECTION: 60% failure rate using replace in a loop (Kenneth Grome 2010)
BTW, we fixed the small bug when the [math] variable name includes a = number ([math]thetest3=3D43[/math]) and we added the new requested tag = [thirurlplusget] so the [thisurl] tag will produce this: /x/y/z/index.dna and the [thirurlplusget] tag will produce this: /x/y/z/index.dna?a=3Db&c=3Dd We are working on the [append] tag that writes to disk and should not. = This behaviour has obviously been previously added to prevent database = loss of data in case of crash, but we think the Administration = configuration that says "Automatically commit databases to disk after = modification", the [closedatabase] tag and the [commitdatabase] provide = security enough. - chris On Jul 19, 2010, at 8:23, Kenneth Grome wrote: >> Ken, i am not sure if you are using [replace] or=20 >> [replacefounditems]. Do not forget [replacefounditems]=20 >> is much faster than the old technique of nesting a [replace]=20 >> context inside a [founditems] context. >=20 > I tried using replacefounditems but that wasn't working in some (but = not all) of my code, so I switched the broken sections to replace -- and = the code that wasn't working before suddenly started working.=20 >=20 > This made me think that maybe there's a bug in replacefounditems. I = was going to report it but when I changed my code from replacefounditems = to replace I over-wrote the failing replacefounditems code and I didn't = have the time to go back and re-write it in order to post to the list = for a confirmation of the problem/bug. >=20 > BTW, last night I streamlined the "replace in a loop" code that was = taking 10-15 seconds to replace 45 db records. I ended up shaving 1-2 = seconds off the elapsedtime. That's not nearly enough of an improvement = for what I need to do -- the response time was still way too slow -- so = I had to rewrite everything anyways, but at least I got it to run a = little bit faster. >=20 > If I can find the time to test replacefounditems again this week I = will give it another try. If I have problems again maybe I will think = far enough ahead to save the problematic code and post it to the list = this time around. >=20 > Sincerely, > Kenneth Grome >=20 >=20 >=20 > --------------------------------------------------------- > 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 christophe.billiottet@webdna.us

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:

SERIAL NUMBER PROBLEM *AGAIN*!!! (1998) Single Link browsing (1997) autosensing lanague selection (1997) Using Applescript to process WebCatalog functions (1998) PIXO support (1997) color (1999) Is there a max number of fields? (1998) Loosing Quantity (2000) Odd Cart Behavior (1997) Auto entering Friday's date in a field (2002) WC2b15 File Corruption (1997) WebCat2 - many [carts] on one template page? (1997) Test (2002) RE: Signal Raised (1997) Need a silver bullet (2004) Store Builder, technical infos (1998) Still ignoring the 3.x bugs? (2000) Generating Report Totals (1997) Size limit for tmpl editor ? (1997) Help formatting search results w/ table (1997)