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 = 105618
interpreted = N
texte = Ken, i am not sure if you are using [replace] or [replacefounditems]. Do = not forget [replacefounditems] is much faster than the old technique of = nesting a [replace] context inside a [founditems] context. - chris On Jul 18, 2010, at 23:24, Kenneth Grome wrote: >> Did you check if the [replace] tag actually writes to disk? >=20 > My tests confirm that replace will NOT write to disk, so that's not = the cause of the slowdown. =20 >=20 > I'm disappointed that my first coding approach was so slow that it was = essentially unworkable. I didn't have any idea that it would take more = than a fraction of a second to do a set of 9 replaces. But there were = two searches before the 9 replaces, and the db's were not tiny, so one = or both of these factors was apparently causing each set to taking 2-3 = seconds to complete. >=20 > Now I'm re-structuring my code to try an approach that might be = faster.=20 >=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)
Ken, i am not sure if you are using [replace] or [replacefounditems]. Do = not forget [replacefounditems] is much faster than the old technique of = nesting a [replace] context inside a [founditems] context. - chris On Jul 18, 2010, at 23:24, Kenneth Grome wrote: >> Did you check if the [replace] tag actually writes to disk? >=20 > My tests confirm that replace will NOT write to disk, so that's not = the cause of the slowdown. =20 >=20 > I'm disappointed that my first coding approach was so slow that it was = essentially unworkable. I didn't have any idea that it would take more = than a fraction of a second to do a set of 9 replaces. But there were = two searches before the 9 replaces, and the db's were not tiny, so one = or both of these factors was apparently causing each set to taking 2-3 = seconds to complete. >=20 > Now I'm re-structuring my code to try an approach that might be = faster.=20 >=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:

Duplicate emails being sent - only since last night (2002) For you Unix gurus [OT] (2002) WebDNA Writer Needed (1997) 'RequiredField' Question (1998) delete fails (2000) Suffix Mapping (1997) NT or Mac (1997) Hosts (2000) ConvertChars (2000) Getting Emailer to send mail (1997) RE:It just Does't add up!!! (1997) Question about replacing words (1998) [WriteFile] problems (1997) Fwd: Problems with Webcatalog Plug-in (1997) Date Range Issue (2006) Search design (1997) Unable to view next 101-200 (1997) Line items in table cells (1997) Using WC for Bulk Emailings (1997) Programmer Needed (1998)