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 inabout 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 orreplaces? Is there anything I can do to alleviate the problem? (bumpmaxfound 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 inabout 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 orreplaces? Is there anything I can do to alleviate the problem? (bumpmaxfound 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:
Bug? (1997)
Email within tmpl ? (1997)
send mail problem? (1997)
Document Contains No Data! (1997)
Webmerchant confirmation hooks? (1997)
2nd WebCatalog2 Feature Request (1996)
WebCatalog Hosting (1996)
# fields limited? (1997)
One more try (1997)
newcart (1997)
WebCatalog for guestbook ? (1997)
Mixing and/or in searches (1998)
SSL and WebCatalog (1997)
creator code (1997)
Plugin or CGI or both (1997)
Reversed words (1997)
wc 2 pro users - sites, quotes wanted (1997)
How can I do (2000)
Number of Open Databases (1998)
OT: javascript help (2003)