Re: Why is deleting so slow?
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 42587
interpreted = N
texte = Mine deleted everything before a certain date .. It was a log file I forgot about ;)Does the ST field only contain a letter - I would think this would go ok.You sure you have the latest 4.5.0 full release ?What platform ?> Did you delete 'everything' or a selective set? > > Here's my code > [delete db=^nwmls/data/current.tab&woSTdata=E,X] > > I tried eqSTdata=E > > And 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/ ------------------------------------------------------------- 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:
Mine deleted everything before a certain date .. It was a log file I forgot about ;)Does the ST field only contain a letter - I would think this would go ok.You sure you have the latest 4.5.0 full release ?What platform ?> Did you delete 'everything' or a selective set? > > Here's my code > [delete db=^nwmls/data/current.tab&woSTdata=E,X] > > I tried eqSTdata=E > > And 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/ ------------------------------------------------------------- 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/
Alain Russell
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:
form data submission gets truncated (1997)
OT: Please set your computer's clock (1997)
[WebDNA] group searching not working as expected. (2010)
Formating found categories (1997)
WebCatalog not recognizing ShoppingCarts folder (2000)
Affiliate Marketing Question #2 (1998)
Max Record length restated as maybe bug (1997)
update on include (1997)
My URL, Your URL (2002)
Temp DBs (2007)
Sherlock and WebCat (1998)
Running _every_ page through WebCat-error.html (1997)
Not reading code (1997)
DataBaseHelper Flawed (1997)
Clean source code (2007)
Hard Questions ? (1997)
WebDNA Intranet Edition release (2002)
Bug? (1997)
Re:quit command on NT (1997)
RePost: NAT and the CART (1999)