|Subject||Re: [ib-support] GDB Size|
|Author||Robert F. Tulloch|
> 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???