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
>

BTW - I don't know which component set you use to connect but there are some
nice IBO components which zip blob contents on the fly before sending over
the wire, and unzipping again upon receipt over the wire. It saves overall
db size and improves over-the-wire performance.
Alan