Subject Re: Help With Freeing Space After Deleting
Author milizarr
--- In firebird-support@yahoogroups.com, "milizarr" <milizarr@y...> wrote:
> I have a table that contains BMP images that are collected
> from a Microscope for cancer screening. The recent images (those newer
> than 2 months old) are stored in the table, those that are older, are
> packed in a special format and archived. Once they are packed the
> record is deleted but looks like the table is not freeing the space, I
> have tried a sweep but the size of the FDB file does not decrease. In
> paradox I use to do a "pack" and the space was freed. Any advise is
> greatly welcome
>
> Thanks
>
> Mariano

Alan and Alexandre,
Thanks so much for your help, I will most likely do what you guys
suggest, that means delete the record and let the DBMS take care of
the space as long as it does not grow for ever :-). I will also take a
look at the IBO components you talk about, actually I am using those
in Delphi and did not know about the zip capability, I guess it helps
to read the help file :-).

Cheers

Mariano Lizarraga