David,

The limits expressed in the documents are correct.

Although some of your queries, lead into a few of my own for you.

- What type of data are you going to be storing? (You seemed concerned
about the 32TB storage limit)

- How many tables are you looking to create? (you asked if the 64K
limit to the number of tables could be increased)

- How many records will you be storing? (The # of records is stored as
a 32bit value -- unsigned integer)


Sean

-----Original Message-----
From: David J N Begley [mailto:d.begley@...]
Sent: Monday, August 28, 2000 3:35 AM
To: IBDI@egroups.com
Subject: [IBDI] database capacity


Does anyone know if the numbers quoted for IB's database capacity:

http://www.interbase.com/open/research/tech_specs.html

are still accurate for InterBase 6.0? Note, I'm looking for actual
limits not
just an indication that database size 'x' appears to work. I have
around 90GB
worth of raw data (a few billion rows) I'd like to move from being in
text
files into an SQL database so people can do something useful with the
information. In particular the limits I'm most interested in checking
are:

- maximum size of database
- measured either in total number of tables or just maximum raw
data capacity
- documented limit is 32TB data, 64K tables (could this be expanded,
are
we talking a limit of 64,000 or 65,536?)

- maximum size of one table
- measured in raw data capacity
- documented limit is 32TB

- maximum number of rows per table
- documented limit is 4G rows (could this also be expanded to give the
real number as "giga" could mean either 4,294,967,296 or
4,000,000,000)

Thanks..


dave



Community email addresses:
Post message: IBDI@onelist.com
Subscribe: IBDI-subscribe@onelist.com
Unsubscribe: IBDI-unsubscribe@onelist.com
List owner: IBDI-owner@onelist.com

Shortcut URL to this page:
http://www.onelist.com/community/IBDI