| Subject | Re: [firebird-support] Primary Key Size Limit |
|---|---|
| Author | Ann W. Harrison |
| Post date | 2005-04-19T16:00:38Z |
Mike Metcalfe wrote:
summarized as:
1) The limit is increased in Firebird2 to 1/4 of the page size.
2) Why are you using such a long primary key. There is a general but
not universal belief that primary keys should be artificial 64bit
integers that can be guaranteed stable.
Regards,
Ann
> Hi,This is a good place, and I thought I saw several answers. They can be
>
> I asked this list about the primary key size limit of 255 chars the other
> day and got no replies. I'm new to Firebird and would like to know where is
> the best place to ask get an answer.
summarized as:
1) The limit is increased in Firebird2 to 1/4 of the page size.
2) Why are you using such a long primary key. There is a general but
not universal belief that primary keys should be artificial 64bit
integers that can be guaranteed stable.
Regards,
Ann