Re: Why is deleting so slow?

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 42586
interpreted = N
texte = Did you delete 'everything' or a selective set?Here's my code [delete db=^nwmls/data/current.tab&woSTdata=E,X]I tried eqSTdata=EAnd 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/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Why is deleting so slow? (Aaron Lynch 2002)
  2. Re: Why is deleting so slow? (Aaron Lynch 2002)
  3. Re: Why is deleting so slow? (Alain Russell 2002)
  4. Re: Why is deleting so slow? (Aaron Lynch 2002)
  5. Re: Why is deleting so slow? (Alain Russell 2002)
  6. Re: Why is deleting so slow? (Aaron Lynch 2002)
  7. Re: Why is deleting so slow? (Alain Russell 2002)
  8. Why is deleting so slow? (Aaron Lynch 2002)
Did you delete 'everything' or a selective set?Here's my code [delete db=^nwmls/data/current.tab&woSTdata=E,X]I tried eqSTdata=EAnd 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/ 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:

WebSTAR 2.1 freezes my Mac (1997) RE: Explorer oddities (1997) Changing price for a SLU based on options (size, etc.) (1997) Emailer (WebCat2) (1997) More Shopping Cart Problems (2000) international time (1997) Date Sorting (1997) New public beta available (1997) %@#*& back button!!! (1999) WebCat editing, SiteGuard & SiteEdit (1997) Shipping Via Actual UPS/FEDEX Zones (1999) Re:Searching for ALL / empty form field (1997) New Plug-in and Type 11 errors (1997) Server slowing down. (1997) How to Sort Summ data ? (1997) Searching on 3 different fields *CORRECTION* (2003) [lookup] [search] Issue (2005) [TaxableTotal] - not working with AOL and IE (1997) MATH TIME (1997) ShowNext example for GeneralStore (1997)