Re: Large founditems loops
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 32488
interpreted = N
texte = I agree.>I understand this, but if webcat is runningn out of thread memory, it>should be saying so, and NOT just quitting webstar. on WebCat 3.08 it>gives me a not enough memory error, but on 4.0 it just quits webstar.>>Derek>>>Then that's not the reason it's failing ... :)>>You probably need to increase your threadmem preference ...>>>>>I neglected to mention that I only put the comments there so I could>>>break the code up... it was actually all on one line...>>>>>>Derek>>>>>>> >ok, i have had a hard time narrowing this down, but basically, I>>>>am running:>>>>>>>>>>[SEARCH db=/db/somedb.db&neSKUdatarq=[BLANK]]>>>>> [FOUNDITEMS]>>>>> [REPLACE DB=/db/someotther.db&eqSKUdatarq=[SKU]&append=T][!]>>>>> [/!]sku=[SKU]&something=[SOMETHING][!]>>>>> [/!][/REPLACE]>>>>> [/FOUNDITEMS]>>>>>[/SEARCH]>>>>>>>>>>and this is processing about 16000 records... the problem is, that>>>>>when webcatalog runs out of memory, instead of saying Web Catalog>>>>>does not have enough memory to complete this command it just quits>>>>>webstar...>>>>>>>>>>>>Try removing the webdna comment tags and use the proper syntax>>>>without those tags, I think they overload the thread memory capacity>>>>in the MacOS version ...>>>>>>>>There's some kind of a problem or bug in the MacOS version of>>>>webcatalog when using the webdna comment technique you illustrated>>>>above. It seems to 'give up' or crash whenever you use too many of>>>>them in one place, such as the 32,000 pairs of them in your example>>>>above. My personal tests broke when less than 50 of them were used in>>>>a single include file, and your 32,000 far exceeds my 50 ...>>>>>>>>I discovered this problem a *very* long time ago, and I reported it a>>>>couple of times while asking for an explanation -- but SM has never>>>>bothered to reply with an explanation, nor have they bothered to fix>>>>it ... :(>>>>>>>>>>>>================================>>>>Kenneth Grome, WebDNA Consultant>>>>808-737-6499 http://webdna.net>>>>================================>>>>>>>>>>>>>>>>#############################################################>>>>This message is sent to you because you are subscribed to>>>> the mailing list
.>>>>To unsubscribe, E-mail to: >>>>To switch to the DIGEST mode, E-mail to>>>>>>>>To switch to the INDEX mode, E-mail to>>>>>>>>Send administrative queries to>>>>>>>>>>-->>>>>>Derek Chauran>>>Web Developer, Dark Horse Comics>>>derekc@darkhorse.com>>>http://www.darkhorse.com>>>>>>#############################################################>>>This message is sent to you because you are subscribed to>>> the mailing list .>>>To unsubscribe, E-mail to: >>>To switch to the DIGEST mode, E-mail to>>>>>>To switch to the INDEX mode, E-mail to>>>>>>Send administrative queries to >>>>>>>>>>>================================>>Kenneth Grome, WebDNA Consultant>>808-737-6499 http://webdna.net>>================================>>>>>>>>#############################################################>>This message is sent to you because you are subscribed to>> the mailing list .>>To unsubscribe, E-mail to: >>To switch to the DIGEST mode, E-mail to>>>>To switch to the INDEX mode, E-mail to>>>>Send administrative queries to >>-->>Derek Chauran>Web Developer, Dark Horse Comics>derekc@darkhorse.com>http://www.darkhorse.com>>#############################################################>This message is sent to you because you are subscribed to> the mailing list .>To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to >>To switch to the INDEX mode, E-mail to >>Send administrative queries to ================================Kenneth Grome, WebDNA Consultant808-737-6499 http://webdna.net================================#############################################################This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to To switch to the INDEX mode, E-mail to Send administrative queries to
Associated Messages, from the most recent to the oldest:
I agree.>I understand this, but if webcat is runningn out of thread memory, it>should be saying so, and NOT just quitting webstar. on WebCat 3.08 it>gives me a not enough memory error, but on 4.0 it just quits webstar.>>Derek>>>Then that's not the reason it's failing ... :)>>You probably need to increase your threadmem preference ...>>>>>I neglected to mention that I only put the comments there so I could>>>break the code up... it was actually all on one line...>>>>>>Derek>>>>>>> >ok, i have had a hard time narrowing this down, but basically, I>>>>am running:>>>>>>>>>>[SEARCH db=/db/somedb.db&neSKUdatarq=[BLANK]]>>>>> [founditems]>>>>> [REPLACE DB=/db/someotther.db&eqSKUdatarq=[SKU]&append=T][!]>>>>> [/!]sku=[SKU]&something=[SOMETHING][!]>>>>> [/!][/REPLACE]>>>>> [/FOUNDITEMS]>>>>>[/SEARCH]>>>>>>>>>>and this is processing about 16000 records... the problem is, that>>>>>when webcatalog runs out of memory, instead of saying Web Catalog>>>>>does not have enough memory to complete this command it just quits>>>>>webstar...>>>>>>>>>>>>Try removing the webdna comment tags and use the proper syntax>>>>without those tags, I think they overload the thread memory capacity>>>>in the MacOS version ...>>>>>>>>There's some kind of a problem or bug in the MacOS version of>>>>webcatalog when using the webdna comment technique you illustrated>>>>above. It seems to 'give up' or crash whenever you use too many of>>>>them in one place, such as the 32,000 pairs of them in your example>>>>above. My personal tests broke when less than 50 of them were used in>>>>a single include file, and your 32,000 far exceeds my 50 ...>>>>>>>>I discovered this problem a *very* long time ago, and I reported it a>>>>couple of times while asking for an explanation -- but SM has never>>>>bothered to reply with an explanation, nor have they bothered to fix>>>>it ... :(>>>>>>>>>>>>================================>>>>Kenneth Grome, WebDNA Consultant>>>>808-737-6499 http://webdna.net>>>>================================>>>>>>>>>>>>>>>>#############################################################>>>>This message is sent to you because you are subscribed to>>>> the mailing list .>>>>To unsubscribe, E-mail to: >>>>To switch to the DIGEST mode, E-mail to>>>>>>>>To switch to the INDEX mode, E-mail to>>>>>>>>Send administrative queries to>>>>>>>>>>-->>>>>>Derek Chauran>>>Web Developer, Dark Horse Comics>>>derekc@darkhorse.com>>>http://www.darkhorse.com>>>>>>#############################################################>>>This message is sent to you because you are subscribed to>>> the mailing list .>>>To unsubscribe, E-mail to: >>>To switch to the DIGEST mode, E-mail to>>>>>>To switch to the INDEX mode, E-mail to>>>>>>Send administrative queries to >>>>>>>>>>>================================>>Kenneth Grome, WebDNA Consultant>>808-737-6499 http://webdna.net>>================================>>>>>>>>#############################################################>>This message is sent to you because you are subscribed to>> the mailing list .>>To unsubscribe, E-mail to: >>To switch to the DIGEST mode, E-mail to>>>>To switch to the INDEX mode, E-mail to>>>>Send administrative queries to >>-->>Derek Chauran>Web Developer, Dark Horse Comics>derekc@darkhorse.com>http://www.darkhorse.com>>#############################################################>This message is sent to you because you are subscribed to> the mailing list .>To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to >>To switch to the INDEX mode, E-mail to >>Send administrative queries to ================================Kenneth Grome, WebDNA Consultant808-737-6499 http://webdna.net================================#############################################################This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to To switch to the INDEX mode, E-mail to Send administrative queries to
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:
Date Calulation (1997)
[WebDNA] WebDNA7 and mod_fcgi (2013)
WebCat2b15MacPlugin - showing [math] (1997)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
Introduction/Tutorial/QuickStart (1997)
Merry Christmas (2002)
WebCat2 - [format thousands] (1997)
THANKS!!! ShipCosts.db and debugging (1997)
Link with [cart] in db field (1999)
carriage returns in data (1997)
Add to Cart & List of Products (1997)
TemplateCacheSize preference! (1998)
Re:Change WebDNA-Talk Mail due to no digest for 1wk (1997)
More WebMerch<->MacAuthoriz (1997)
WebCatalog can't find database (1997)
Summing fields (1997)
date tag not interpreted (2000)
Webcatalog and foreign languages (1998)
how do you and/or in a search? (1997)
Webstar 1.3.1 PPC (1997)