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.- chrisOn 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:
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.- chrisOn 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)