Subject | Re: [ib-support] GDB Size |
---|---|
Author | Robert F. Tulloch |
Post date | 2001-02-10T03:00:10Z |
> Hi:Additionally:
>
> I had gdb ~ 6mb. I added table:
>
> Table ALLZIP with fields:
>
> CITY VARCHAR(50)
> STATE CHAR(2)
> ZIP CHAR(6)
>
> I set up dialect 1 database with one table ALLSTATE with three fields:
>
> UCITY VARCHAR(50)
> USTATE CHAR(2)
> UZIP CHAR(6)
>
> I pumped the data into this from dBase table (46797 records) with datapump.
>
> The dBase table was 1.8 mb. After datapumping the data into the dialect 1 gdb, that
> gdb was 12+ mb. I then used IB_WSQL to pump the data from the Dialect 1 to the Dialect
> 3 .gdb. It wnet from 6 mb to 10+ mb.
>
> 1. What is the minimum size of a gdb with no data (approximately)?
>
> 2. Why would data from dBase which only used 1.8 mb require so much more in IB?
>
> 3. Why would that same data that produced a 12 mb .gdb in Dialect 1 only increase
> size of Dialect 3 by ~ 4 mb?
>
> Any insight here appreciated.
>
> Best regards
I did backup of 12 mb gdb and the backup was 1.8 mb and the restore was 3.7 mb, down
from 12 mb???
What gives?