Re: Why is deleting so slow?
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 42585
interpreted = N
texte = When I tried the new delete code it deleted 1 million records in no time atall ?? 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/
Associated Messages, from the most recent to the oldest:
When I tried the new delete code it deleted 1 million records in no time atall ?? 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/
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:
Professional WebDNA Hosting Solutions (2005)
CommandSecurity? (1997)
RE: format problem on NT? (1997)
Practice runs ? (1997)
Nested vs conditional (1997)
Associative lookup style? (1997)
ConvertChars (2000)
Car Database (2002)
Error Lob.db records error message not name (1997)
WebCatalog2 Feature Feedback (1996)
PCS Frames (1997)
Referrer problem - Truncation (1998)
2.0 Info (1997)
Meet your competition (2000)
ooops...WebCatalog [FoundItems] Problem - LONG - (1997)
Assigning carts (1998)
I'm new be kind (1997)
Shipping Help! (1998)
Trouble with formula.db + more explanation (1997)
Big Databases (1997)