Why is deleting so slow?
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 42582
interpreted = N
texte = 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/
Associated Messages, from the most recent to the oldest:
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/
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:
one item in several different categories? (2000)
Copyright that puppy (1998)
Stupid Format grrrrrrrr.... (2004)
[WebDNA] WebDNA 8.6 announced - New features (2018)
Nested tags count question (1997)
why am I getting an authenticate dialog with no [protect]? (2000)
really wierd browser truncating (1997)
[WebDNA] Migration from 6.2 to 7. Problems with writing to DB's (2012)
remotely add + sign (1997)
pop up menu's (1998)
[numfound] for [listfiles] (1998)
How To get Some Help (2003)
WebCatalog not recognizing ShoppingCarts folder (2000)
Location of Browser Info.txt file (1997)
OT (But could use some help) Meta refresh not working. (2001)
Search Form (2000)
Stumped by [thisUrl] (2006)
Error 11 (1996)
[WebDNA] Email time bug? YES, it's a bug! (2011)
WebDelivery downloads alias, not original ? (1997)