.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