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)