Subject RE: [firebird-support] Help With Freeing Space After Deleting
Author Alan McDonald
> 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

only backup and restore will finally restore the original size. But in your
case, the db will reach a maximum size and just stay there since your
operations will remove the space allowing next months additions to take up
that space again. It will not grow forever. just watch it you will see what
I mean.
Alan