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 mbdbase2 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:

Re: Too many lines too add in one go (Tim Robinson 2003)
OT: Re: Too many lines too add in one go (Rene van der Velde 2003)
Re: Too many lines too add in one go (Rene van der Velde 2003)
Re: Too many lines too add in one go (WJ Starck 2003)
Re: Too many lines too add in one go (Tim Robinson 2003)
Too many lines too add in one go (Rene van der Velde 2003)

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 mbdbase2 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!

Re: Too many lines too add in one go

2003

Top Articles:

Related Readings: