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:
PCS Frames (1997)
Stopping bad HTML propagation ? (1997)
What am I missing (1997)
[WebDNA] Feature Request (2013)
autosensing lanague selection (1997)
Copyright ? (1997)
Cart questions (1997)
Showing unopened cart (1997)
DON'T use old cart file! (1997)
Re:2nd WebCatalog2 Feature Request (1996)
Rubbish in form fields (2004)
Re:Emailer and encryption (1997)
PCS Customer submissions ? (1997)
Quickie question on the email templates (1997)
Quit revisited (1997)
Showif -what am I missing??? (1999)
[WebDNA] Lookup inside grep?... (2011)
Notice To ICVerify Users (2000)
Re[2]: 2nd WebCatalog2 Feature Request (1996)
[TaxableTotal] - not working with AOL and IE (1997)