You need to compute how many rows will fit on each page. The
"Administration Guide - Planning" has detailed information about how to
do this. See the section "Space requirements for user table data" for
detailed information.
A quick estimate for a 4k page size is:
(1+freespace percentage)*num rows/(int(4028/(rowsize+10)))
Don't forget to plan for space for indexes.
Rows with varchar data in them will, as a general rule, take up less
space than the maximum. This will (usually) allow more rows per page
than the basic calculation indicates. Use the average length of the
varchar column when computing row size.
There are also some other some other considerations that come into play
when the row size is a large percentage of the page size. These relate
the data manager's ability to find space for a new row to be inserted.
At the other end of the scale, if the row size is very small, then you
can hit the limit of maximum rows on a page.
Phil Sherman
sandip wrote:
Hi,
Can anyone tell me how to calculate the ctual disk space needed for a
table? The record length and number of records are known.
A rough estimate of the disk space would suffice.
Please help.
Thanks,
Sandip.