Subject | Re: [firebird-support] FDB < FBK |
---|---|
Author | Ann W. Harrison |
Post date | 2008-11-15T04:33:17Z |
Aage Johansen wrote:
Aage Johansen wrote:
fields, have lots of nulls, and very few indexes, the backup can be
bigger than the database because data in the backup is not compressed.
This is NOT true of Nbak.
Good luck,
Ann
> Leyne, Sean wrote:Generally (as usual) Sean is right.
> > ...
> > The FBK is the most compressed natural representation of a database that
> > can be made -- containing none of the overhead that is required for an
> > operational database (Indexes data, RDB$Pages table, record and page
> > headers).
Aage Johansen wrote:
>In specific (and aberrant) cases, Aage is right. If you over specify
> Field contents in the database are compressed, will data in the
> backup file also be compressed?
> I have seen databases where the fbk is just slightly smaller than the fdb.
fields, have lots of nulls, and very few indexes, the backup can be
bigger than the database because data in the backup is not compressed.
This is NOT true of Nbak.
Good luck,
Ann