Subject | Re: Max number of fields |
---|---|
Author | Adam |
Post date | 2005-09-17T00:07:06Z |
--- In firebird-support@yahoogroups.com, "rainingmanca"
<rainingmanca@y...> wrote:
What is the ballpark for "large". I am not exactly sure if there is a
specific limit, but I know each row is 32k or therabouts, so depending
on your field definitions, this limit may be more significant.
http://www.ibphoenix.com/main.nfs?a=ibphoenix&l=;FAQS;NAME='System+Limits'
To be honest, I have not seen many tables with large numbers of fields
that are normalised correctly. Perhaps if you provide an example of
what you are trying to do, a better solution can be found.
Adam
<rainingmanca@y...> wrote:
> Hi,Igor,
>
> I have to create table with large # of fields.
>
> I would like to know what is the maximum number of fields I can create
> in firebird database?
>
> Thanks
>
> Igor
What is the ballpark for "large". I am not exactly sure if there is a
specific limit, but I know each row is 32k or therabouts, so depending
on your field definitions, this limit may be more significant.
http://www.ibphoenix.com/main.nfs?a=ibphoenix&l=;FAQS;NAME='System+Limits'
To be honest, I have not seen many tables with large numbers of fields
that are normalised correctly. Perhaps if you provide an example of
what you are trying to do, a better solution can be found.
Adam