Re: Too many lines too add in one go
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 50425
interpreted = N
texte = ok here she goes then :)if i put a max=1000 in the first search it won't time out. i tried it without the replace, so its one of the searches that is timing out and not the replace. How can i put the whole thing in a loop of smaal chunks?dbase1 contains +/- 6000 items less than 1 mb dbase2 contains +/- 11000 items +/-1,4MBand now the code..... ---------------------------------------------------------------- [search db=/db/dbase1.db&neSKUdatarq=dikkelul] [founditems] [search db=/db/dbase2.db&eqOrderSKUdatarq=[SKU]] [math show=F]numsold=0[/math] [founditems] [math show=f]numsold=[math]numsold[/math]+[OrderQTY][/math] [/founditems] [/search]sku=[SKU], Sold=[numsold]
[replace append=T&db=/db/topskus.db&eqSKUdatarq=[SKU]]sold=[numsold][/replace] [/founditems] [/search] [closedatabase db=/db/dbase1.db]-----------------------------------------------------------------On vrijdag, 16 mei 2003, WJ Starck
wrote: >What are you replacing that causes a time out? > >This sounds a bit unusual. > >I'd make sure you don't have some faulty code somewhere. > >Other things to try: > >1) Increase the seconds to wait for busy database in your WebDNA prefs >2) Add RAM (if possible) > >Show us a code snippet... > >-- > >Will Starck >NovaDerm Skincare Science >http://www.novaderm.com >wjs@novaderm.com > > >On Friday, May 16, 2003, at 05:34 AM, Tim Robinson wrote: > >> I would say that it depends what you are replacing. If it's possible >> to use >> the [replacefounditems] context, use that. You could possibly use >> [spawn], >> but it would help to post the appropriate code... >> >> Regards, >> Tim >> >>> From: Rene van der Velde >>> Reply-To: (WebDNA Talk) >>> Date: 16 May 2003 11:59:43 >>> To: (WebDNA Talk) >>> Subject: Too many lines too add in one go >>> >>> Hello. This is probably a very newbie question but i'm a little stuck >>> here. >>> >>> I'm doing a replace in a db wich times out everytime. >>> >>> So I need to do the replace in chunks. >>> >>> I've been reading up on the Loop context but it only mentiones a >>> fixed start >>> and end variable. The database it is reading from does not have a >>> fixed number >>> of items so i wouldn't know the Last end of the loop. >>> >>> How can I do the replace with chunks of, say 50 items ? >>> >>> >>> ------------------------------------------------------------- >>> 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 >>> >>> Web Archive of this list is at: http://webdna.smithmicro.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 >> >> Web Archive of this list is at: http://webdna.smithmicro.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 >Web Archive of this list is at: http://webdna.smithmicro.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 Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
ok here she goes then :)if i put a max=1000 in the first search it won't time out. i tried it without the replace, so its one of the searches that is timing out and not the replace. How can i put the whole thing in a loop of smaal chunks?dbase1 contains +/- 6000 items less than 1 mb dbase2 contains +/- 11000 items +/-1,4MBand now the code..... ---------------------------------------------------------------- [search db=/db/dbase1.db&neSKUdatarq=dikkelul] [founditems] [search db=/db/dbase2.db&eqOrderSKUdatarq=[SKU]] [math show=F]numsold=0[/math] [founditems] [math show=f]numsold=[math]numsold[/math]+[OrderQTY][/math] [/founditems] [/search]sku=[SKU], Sold=[numsold]
[replace append=T&db=/db/topskus.db&eqSKUdatarq=[SKU]]sold=[numsold][/replace] [/founditems] [/search] [closedatabase db=/db/dbase1.db]-----------------------------------------------------------------On vrijdag, 16 mei 2003, WJ Starck wrote: >What are you replacing that causes a time out? > >This sounds a bit unusual. > >I'd make sure you don't have some faulty code somewhere. > >Other things to try: > >1) Increase the seconds to wait for busy database in your WebDNA prefs >2) Add RAM (if possible) > >Show us a code snippet... > >-- > >Will Starck >NovaDerm Skincare Science >http://www.novaderm.com >wjs@novaderm.com > > >On Friday, May 16, 2003, at 05:34 AM, Tim Robinson wrote: > >> I would say that it depends what you are replacing. If it's possible >> to use >> the [replacefounditems] context, use that. You could possibly use >> [spawn], >> but it would help to post the appropriate code... >> >> Regards, >> Tim >> >>> From: Rene van der Velde >>> Reply-To: (WebDNA Talk) >>> Date: 16 May 2003 11:59:43 >>> To: (WebDNA Talk) >>> Subject: Too many lines too add in one go >>> >>> Hello. This is probably a very newbie question but i'm a little stuck >>> here. >>> >>> I'm doing a replace in a db wich times out everytime. >>> >>> So I need to do the replace in chunks. >>> >>> I've been reading up on the Loop context but it only mentiones a >>> fixed start >>> and end variable. The database it is reading from does not have a >>> fixed number >>> of items so i wouldn't know the Last end of the loop. >>> >>> How can I do the replace with chunks of, say 50 items ? >>> >>> >>> ------------------------------------------------------------- >>> 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 >>> >>> Web Archive of this list is at: http://webdna.smithmicro.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 >> >> Web Archive of this list is at: http://webdna.smithmicro.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 >Web Archive of this list is at: http://webdna.smithmicro.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 Web Archive of this list is at: http://webdna.smithmicro.com/
Rene van der Velde
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:
Extended [ConvertChars] (1997)
when is date system date or order date? (1997)
PC Cookie Problem? (2003)
[WebDNA] Function "libraries" (2009)
Search/sort in URL Was: GuestBook example (1997)
Cart passing in URL... (2004)
lookup and two records? (1997)
DON'T use old cart file! (1997)
re:check boxes (1997)
Virtual hosting and webcatNT (1997)
Emailer or [sendmail] questions ... (1998)
Hiding usernames and passwords in URL (1998)
looping table rows (1999)
Serious WebDNA issue (2006)
Grep question [parsing variables] problem (2003)
searching for items that begin with a number (2004)
Emailer again & again (1997)
[thisurl] (2004)
QuantityPrice computed? (1998)
Showif, Hideif reverse logic ? (1997)