Hi:

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