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:

won't serve .tpl -permissions (2000) Bad creator codes which cause access denied errormessage (1997) Satisfy Me ! (2000) WebCommerce: Folder organization ? (1997) Cross OS Compatible HTML emailing (2003) Variable Math (1998) StoreBuilder Shopping Cart (2000) RE: what characters are replaced for tab and CR? (1998) Emailer error (1998) Tiny Store (1998) Template Encryption (1998) Locking up with WebCatalog... (1997) Extra equals signs with IE? (More debugging questions...) (1997) Shipping Formula % (2003) WC2.0 Memory Requirements (1997) WebCatalog can't find database (1997) Problem with summary on date / inconsequent webcat behaviour (1998) Getting Crazy (1998) CommandSecurity? (1997) Show shoppingcart after remove last item (1997)