Thanx Ann,

I don't know why I didn't received those replies. I'm porting an existing
app and I don't want to redesign anything yet.

And thanx to all who replied.

Mike

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]On Behalf Of Ann W. Harrison
Sent: 19 April 2005 06:01
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Primary Key Size Limit



Mike Metcalfe wrote:

> Hi,
>
> 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.

This is a good place, and I thought I saw several answers. They can be
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




Yahoo! Groups Links