i found a telling point here the other day on maximum size of fields usable
in an index, two 255 char fields and i couldn't create the index, yet two
200 char fields it would let me...

> -----Original Message-----
> From: David J N Begley [mailto:d.begley@...]
> Sent: Monday, 28 August 2000 5:35 PM
> 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
>
>