Good idea Bob, but this also requires a SET LOCK tablename ON command before the code and a SET LOCK tablename OFF command afterwards!
David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Thompson Technology Consultants" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> Sent: Tuesday, April 26, 2005 10:40 PM Subject: [RBASE-L] - Re: Deleting row question > Another method, depending on your application that works > very fast .... > > Project a new table from your old one using > only the rows you want to keep > > R>Project NewTable from Oldtable using all where .... > > Then drop the old table.. > > R>Drop Table OldTable > > Rename the Newtable to Oldtable > > Create indexes as in the original. > > While this may take four lines of code, it often is much faster > than the delete command and has the benefit of new, "clean and > fast" indexes in the resulting table. > > -Bob > > > > Thompson Technology Consultants > 276 Chippewa > LaPorte, IN 46350 > 219-324-2605 (Phone & Fax) > 219-363-7441 (Cell) > http://ttc.inc.home.comcast.net > > > > -----Original Message----- > From: Steve Breen [SMTP:[EMAIL PROTECTED] > Sent: Tuesday, April 26, 2005 8:08 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Re: Deleting row question > > > > David, > > The second method is faster by far. > > It seems that the more rows that are deleted the slower it gets. Ran the > second option first and it just flew thru the process the second one is > running now and it is going to hours. > > I am just going to have to stop it. > > Will use the new concept > > > Thanks David and Razzak > >
