Re: Why is deleting so slow?
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 42583
interpreted = N
texte = 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/
Associated Messages, from the most recent to the oldest:
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/
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:
Extra equals signs with IE? (More debugging questions...) (1997)
can webcat create directories on NT? (1997)
[WebDNA] exclusive lock prevents dbs from closing (2011)
[append] and SSL (1997)
OT: router and load balancer (2004)
Using [Include] Context (1999)
[OT] Bad Cookie / Internet Option / Internet Explorer (2004)
WebCat b13 CGI -shownext- (1997)
Re2: frames & carts (1997)
Anyone get WebDNA working on a windows XP Home box? (2006)
Record size (1998)
OT-Load balance (2004)
WebCat2 Append problem (B14Macacgi) (1997)
selecting multiple found items (1997)
Search design (1997)
sendmail error (2001)
WebCatalog NT beta 18 now available (1997)
any WEBCAT gurus who are also PERL proficient? (1999)
Problems with command=replace in realm (2000)
splitting numbers in webDNA? (1997)