Large files with no records (AREV Specific)
At 15 OCT 1999 06:43:55AM Tim Sneller - mailto:tims@miles33.co.uk wrote:
I have several empty files in Arev 2.x which are still occupying a considerable space on the disk.
These files have been cleared with CLEARFILE, and have ZERO records, but have a large number of groups when DUMPed. One file for example had 34,000 groups, Zero records, and was occupying 34mb of disk space.
I have tried Compressing the file in DUMP, clearing the free frame list etc, but the only remedy seems to be to copy the dictionary to a temporary file, delete the file, make the file, and then copy the dictionary back.
This is OK for data files, but a real PITA for BANG files which exhibit the same problem. With these, I have rebuilt all the indexes after clearing the files, but still end up with large empty files.
Any suggestions as to what is going on please.
At 15 OCT 1999 08:34AM Don Bakke wrote:
Tim,
Did you rebuild the indexes by deleting the OS files and starting from scratch or did you just remove indexes the "normal" way? Do you have a sizelock setting in this file that is preventing it from shrinking?
One suggestion is to throw it into the clothes dryer for 30 minutes or more. Everything comes out smaller than before when I do this…
dbakke@srpcs.com
At 18 OCT 1999 04:53AM Tim Sneller - mailto:tims@miles33.co.uk wrote:
Indexes were removed in the "Normal" way. If I delete the OS file of the BANG file, then obviously, I won't have the problem!!!
Ordinary data files were cleared using CLEARFILE.
Tim
At 18 OCT 1999 10:29AM Don Bakke wrote:
Tim,
What about the SizeLock question?
dbakke@srpcs.com
At 18 OCT 1999 11:07AM Victor Engel wrote:
You need to dump the file and use the - key to reset the sizelock back to zero. A compress is not necessary if you clear a file with sizelock set to 0, because the file is simply truncated when you do the cleartable.