Subject Re: [ib-support] limitations/maximum specs
Author Ann W. Harrison
At 09:53 AM 6/13/2001 +0100, ian wrote:
>Fact? :
>max no of records per table = 2^31 - 1

Fiction. The number of records in a table is a
complex function of page and record size.

>max record size = 64kb (+ blobs)
>max no of tables = 64k

Fact.

>max individual file size = 2gb/4gb ish depending

Fact, though FB1 will change that.


>Rumour? :
>"I've heard about a guy with a 900+ GB database"

In 450 files?! Someone likes to suffer.

>"I know about one company here in Russia" = 300 simultaneous
>connections.

Seems possible. Depends on what they're doing. Just
being connected is not all that complicated - unless
you're running on Windows or Solaris with V5x or less.

Regards,


Ann
www.ibphoenix.com
We have answers.