Re: Why is deleting so slow?
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 42586
interpreted = N
texte = Did you delete 'everything' or a selective set?Here's my code[delete db=^nwmls/data/current.tab&woSTdata=E,X]I tried eqSTdata=EAnd it hung on that too.On 8/15/02 6:20 PM, Alain Russell mashed the following keys :> When I tried the new delete code it deleted 1 million records in no time at> all ?? Not sure what else you can try ..> >> Yes.>> >> Also, I tried setting 'only commit databases to disk when instructed' but it>> made no appreciable difference.>> >> >> On 8/15/02 5:20 PM, Alain Russell mashed the following keys :>> >>> The delete code was re-written in 4.5 ..>>> See the change notes.>>> Are you running the latest release ?>>> >>> Alain>>> >>>> We have a 400 MB db, which I realize is quite large,>>>> >>>> I'm trying to delete approximately 66,000 records (out of 450,000)>>>> And it pegs webcat @ 100% for over twenty minutes.>>>> >>>> Changing 'delete' into 'search' on the context yields a numfound result in>>>> about 2 seconds.>>>> >>>> I can use copyfile to copy the entire 400 megs in about 15 seconds,>>>> >>>> So why's webcatalog falling apart when trying to do large deletes or>>>> replaces? Is there anything I can do to alleviate the problem? (bump>>>> maxfound to a million or something?)>> >> >> ------------------------------------------------------------->> 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://search.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://search.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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Did you delete 'everything' or a selective set?Here's my code[delete db=^nwmls/data/current.tab&woSTdata=E,X]I tried eqSTdata=EAnd it hung on that too.On 8/15/02 6:20 PM, Alain Russell mashed the following keys :> When I tried the new delete code it deleted 1 million records in no time at> all ?? Not sure what else you can try ..> >> Yes.>> >> Also, I tried setting 'only commit databases to disk when instructed' but it>> made no appreciable difference.>> >> >> On 8/15/02 5:20 PM, Alain Russell mashed the following keys :>> >>> The delete code was re-written in 4.5 ..>>> See the change notes.>>> Are you running the latest release ?>>> >>> Alain>>> >>>> We have a 400 MB db, which I realize is quite large,>>>> >>>> I'm trying to delete approximately 66,000 records (out of 450,000)>>>> And it pegs webcat @ 100% for over twenty minutes.>>>> >>>> Changing 'delete' into 'search' on the context yields a numfound result in>>>> about 2 seconds.>>>> >>>> I can use copyfile to copy the entire 400 megs in about 15 seconds,>>>> >>>> So why's webcatalog falling apart when trying to do large deletes or>>>> replaces? Is there anything I can do to alleviate the problem? (bump>>>> maxfound to a million or something?)>> >> >> ------------------------------------------------------------->> 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://search.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://search.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://search.smithmicro.com/
Aaron Lynch
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:
WebSTAR 2.1 freezes my Mac (1997)
RE: Explorer oddities (1997)
Changing price for a SLU based on options (size, etc.) (1997)
Emailer (WebCat2) (1997)
More Shopping Cart Problems (2000)
international time (1997)
Date Sorting (1997)
New public beta available (1997)
%@#*& back button!!! (1999)
WebCat editing, SiteGuard & SiteEdit (1997)
Shipping Via Actual UPS/FEDEX Zones (1999)
Re:Searching for ALL / empty form field (1997)
New Plug-in and Type 11 errors (1997)
Server slowing down. (1997)
How to Sort Summ data ? (1997)
Searching on 3 different fields *CORRECTION* (2003)
[lookup] [search] Issue (2005)
[TaxableTotal] - not working with AOL and IE (1997)
MATH TIME (1997)
ShowNext example for GeneralStore (1997)