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!
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:
Num Sort Descending (2004)
[isfile] ? (1997)
Templates for Customer Database? (1997)
[WebDNA] How to activate error logging (2019)
PIXO (1997)
Requiring that certain fields be completed (1997)
converting tabs (1997)
Why is my easy [AddLineItems] NOT working?? (2000)
instant cookies? (1999)
Moment of Thanks (1997)
.eml files (2001)
Error Lob.db records error message not name (1997)
bcc and sendmail (2001)
[WebDNA] Using WebDNA with MAMP (2010)
ShowNext (1997)
Repeating Fields (1997)
email [title] (1997)
SQL, ODBC and MySql (2002)
pop up menu's (1998)
Problem (1997)