Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Size of DBISAM tables
Sun, Apr 8 2007 10:25 AMPermanent Link

John
Hi.

How do I manually calculate how much space a table will take?
Mon, Apr 9 2007 8:16 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

John,

<< How do I manually calculate how much space a table will take? >

It's somewhat difficult due to the fact that you must take into account
index compression, BLOBs, and other attributes that are virtually impossible
to calculate ahead of time without considering the actual data being stored.

A rough estimate is to simply use the record size of the table multiplied by
the potential number of records.  You can find the record size for a table
by viewing the table in the DBSYS utility and clicking on the Structure tab.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image