Subject | RE: [firebird-support] Re: Help With Freeing Space After Deleting |
---|---|
Author | Alan McDonald |
Post date | 2005-06-04T13:48:22Z |
> --- In firebird-support@yahoogroups.com, "milizarr" <milizarr@y...> wrote:they are not in the native components - look at the user contributed
> > 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
components
Alan