Hi,

There are a lot of factors that affect the db size. Also, 'size' can be expressed in many different ways. I am assuming that you are after the physical size on the disk.

This is a simple method that I used to estimate required disk space for a table.

1. Calculate the space required for each row. (Use vsize function to do this. You might need to create a dummy/empty table first)
2. Calculate the number of rows per block. ( DB_BLOCK_SIZE/RowSize)
3. Calculate blocks required. (RowCount*RowsPerBlock)
4. Calculate TableSize. ((BlocksRequired*DB_BLOCK_SIZE)/1024)

Obviously, the system tables require a lot of space as well. Again, as a rough estimate, I used to add 20% for this.

Mace