Re: Corrupted SE version 5.0 table

In article <estal.6.0560DE65@mcs.com> estal@mcs.com "John Estal" writes: >I'm using SE version 5 and have a 350,000 row table. I try to use esql/c with >a delete from table to remove all the rows. It took about 12 hours of >processor time on a multi-processor NCR 3555 to delete all the rows. It took I assume that this DELETE is being done for a specific reason. It would be *much* faster to just DROP the table and then CREATE it again if you know you're going to delete all the records. As to the .idx problem, I'm afraid I can't add anything constructive, I can only agree that it must have been the re-boot seriously corrupting your indexes. FWIW, I remember the older versions of SE had flaky bchecks that you had to run repeatedly to make sure that it actually fixed everything; just running it once was no guarantee that it had actually worked! HTH, Spokey the Wheeler------------------------------------------------------------- "Billy Boy" - das aufregend andere kondom! Carter - the Unstoppable Sex Machine / Wheeler - the Unstoppable Mail Machine!