Subject | RE: [firebird-support] Help With Freeing Space After Deleting |
---|---|
Author | Alan McDonald |
Post date | 2005-06-03T23:41:04Z |
>BTW - I don't know which component set you use to connect but there are some
> 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
>
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