.blb file not shrinking after deleting ALL entries
Robert Brenstein
rjb at rz.uni-potsdam.de
Mon Feb 16 11:03:49 CST 2004
>on 2/15/04 9:59 PM, Andrew Sinning at andrew at learningware.com wrote:
>
>> I asked about this last week, but didn't have time to follow up.
>>
>> I add 100 entries to a table. The table has a single BLOB field. My
>> .blb file grows to 3.5Mb.
>>
>> Now, I execute 2 queries:
>>
>> DELETE FROM testTable
>> COMPACT (I also tried "COMPACT DATABASE" at Ruslan's suggestion)
>>
>>
>> The size of the .blb file is STILL 3.5Mb.
>>
>> If I test the number of records in testTable, I get 0.
>
>Strange.
>
>COMPACT should move it down.
>
>You can use XML dump then to get smaller db.
>
>--
>Best regards,
>Ruslan Zasukhin [ I feel the need...the need for speed ]
Does COMPACT actually rewrite the physical file or compacts only
internal files? If the latter, then disk space allocation might not
change even if the file is empty.
Robert
More information about the Valentina
mailing list