OT: Re: Too many lines too add in one go

This WebDNA talk-list message is from

2003

It keeps the original formatting. numero = 50426
interpreted = N
texte = I hope you guys aren't from the Netherlands because you would know what dikkelul means :)On vrijdag, 16 mei 2003, Rene van der Velde wrote:>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,4MB>>and 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/>-------------------------------------------------------------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:

I hope you guys aren't from the Netherlands because you would know what dikkelul means :)On vrijdag, 16 mei 2003, Rene van der Velde wrote:>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,4MB>>and 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/>-------------------------------------------------------------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!

OT: Re: Too many lines too add in one go

2003

Top Articles:

Related Readings: