Subject Re: [firebird-support] Compress Database
Author Marcello Fontolan
It works.
Now the FDB is with 380KB.

I will have to do this usually?

..::
Marcello Fontolan
marcello@...
::..



Alexandre Benson Smith wrote:

> At 23:05 29/03/2004 -0300, you wrote:
>
> > Hello,
> >
> > I have a database (developing) that is now with 11MB but if I compress
> >(Windows XP ZIP) it's down to 400KB.
> > There is any command to compress the database?
> > If it has a lot of insert and delete, a empty space is allocated?
> >
> > Thank you all!
> >
> >--
> >
> >..::
> > Marcello Fontolan
> > marcello@...
> >::..
> >
>
>
> Hi Marcello,
>
> Do a backup/restore. The size of you database should shrink....
>
> Any way the file will be greater than the ziped file... data are store on
> pages and you could have a lot of free space on pages that zip will
> compress...
>
>
> see you ! (até mais...)
>
>
> Alexandre Benson Smith
> Development
> THOR Software e Comercial Ltda.
> Santo Andre - Sao Paulo - Brazil
> www.thorsoftware.com.br
>
> ----------
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> <http://www.grisoft.com%29.>
> Version: 6.0.631 / Virus Database: 404 - Release Date: 17/03/2004
>
>
> [Non-text portions of this message have been removed]
>
>
> ------------------------------------------------------------------------
> *Yahoo! Groups Links*
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
> * To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
> <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>
> .