Subject Re: [firebird-support] database growing too much after bulk
Author masotti
Hi Sergio,
> I first removed the default '' from the blob field "notas" domain, and imported
> the DBF, and again, the DB grew to 179,00 kb, but then I commented out the line
> in my progran which assigns the blob field, and imported again, and the DB now
> is 12MB, so the problem was in the blob field.
>
>
NULL Blob is different from empty string Blob.
> // ** THIS IS THE BLOB **
> StockNOTAS.asString := DBF_StockNOTA.AsString;
>
if (DBF_StockNOTA.AsString = '') or ( DBF_StockNOTA.IsNull)
then StockNOTAS.Clear
else StockNOTAS.asString := DBF_StockNOTA.AsString;

Try this small change in your code.

HTH.

Ciao.
Mimmo.