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 forgotabout ;)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:

Re: Why is deleting so slow? (Aaron Lynch 2002)
Re: Why is deleting so slow? (Aaron Lynch 2002)
Re: Why is deleting so slow? (Alain Russell 2002)
Re: Why is deleting so slow? (Aaron Lynch 2002)
Re: Why is deleting so slow? (Alain Russell 2002)
Re: Why is deleting so slow? (Aaron Lynch 2002)
Re: Why is deleting so slow? (Alain Russell 2002)
Why is deleting so slow? (Aaron Lynch 2002)

Mine deleted everything before a certain date .. It was a log file I forgotabout ;)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!

Re: Why is deleting so slow?

2002

Top Articles:

Related Readings: