.blb file not shrinking after deleting ALL entries

[Ruslan Zasukhin]

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 ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------