Re: [Firebird-devel] non-transportable backup using without "-se service_mgr" results in an backup file ~50% larger than the source database

[Alex P. <pes...@ma...>]

 On 10/14/10 19:13, Brenden Walker wrote:
>> -----Original Message-----
>> From: Alex Peshkoff [mailto:pes...@ma...]
>> Sent: Thursday, October 14, 2010 2:35 AM
>> To: fir...@li...
>> Subject: Re: [Firebird-devel] non-transportable backup using without "-
>> seservice_mgr" results in an backup file ~50% larger than the source
>> database
>>
>>  On 10/13/10 23:24, Brenden Walker wrote:
>>> I originally posted this to firebird-support and didn't get any
>> feedback, figured I'd post here before entering an issue.
> <..snip>
>> same whether I specify "-se service_mgr" or not, so this appears to be
>> specific to the non transportable format.
>>> I searched the tracker and wasn't able to find an existing issue for
>> this.  I'll add one if that's the correct next step, I just wanted to
>> run this by someone before doing so.
>>> We could likely provide the source database on HD if needed, although
>> I'd probably want to remove more sensitive customer information and
>> retest prior to doing so (for obvious reasons).
>> Looks like a bug. 2 questions:
>> Can you reproduce an issue with database of smaller size?
>> Are both non-transportable backups (big and small) restorable?
> I was able to shrink the database by dropping tables.  The non-service manager backup is no longer larger than the FDB, *however* the .fbk file size is larger than when using the service manager.  I think this is still exhibiting the problem, just not as pronounced.
>
> The database is now 359,280K.
>
> Here are the two test backup command lines I used.
>
> c:gbak.exe -se service_mgr -v -nt -user sysdba -password masterkey d:\temp\i21426\2.5\smalltest\sw_even_smaller.fdb d:\temp\i21426\2.5\smalltest\service_mgr.fbk
>
> c:gbak.exe -v -nt -user sysdba -password masterkey d:\temp\i21426\2.5\smalltest\sw_even_smaller.fdb d:\temp\i21426\2.5\smalltest\no_service_mgr.fbk
>
>
> Here's the directory contents:
>
> Directory of D:\temp\i21426\2.5\smalltest
>
> 10/14/2010  11:06 AM    <DIR>          .
> 10/14/2010  11:06 AM    <DIR>          ..
> 10/14/2010  11:04 AM       175,974,400 no_service_mgr.fbk
> 10/14/2010  11:07 AM       167,070,720 service_mgr.fbk
> 10/14/2010  11:07 AM       367,902,720 SW_EVEN_SMALLER.FDB
>
>
> The difference in file size isn't as large, however I would think that whether using -se service_mgr or not the resulting FBK should be the same size.
Yes, certainly.
Can you compress that fdb and make it available for download?