What is DB_KEY anyway, my tables without unique keys appear to have thsi
field automatically defined.

----- Original Message -----
From: "Jason Wharton" <jwharton@...>
To: <IBObjects@egroups.com>
Sent: Friday, 19 January 2001 15:19
Subject: Re: [IBO] KeyLinks & Primary Keys


> Chris,
>
> What are the dimensions of the unique key columns? If they are sizable
then
> I strongly discourage you using them in the KeyLinks property. If they are
> large they get duplicated and use up more memory than otherwise. Keys and
> data are buffered separately with IBO.
>
> Is there a reason you cannot just use an integer surrogate key column?
>
> Regards,
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
> ----- Original Message -----
> From: "Chris Landowski" <chrisl@...>
> To: <ibobjects@egroups.com>
> Sent: Thursday, January 18, 2001 6:34 AM
> Subject: [IBO] KeyLinks & Primary Keys
>
>
> > I have several tables in a database that have no primary keys. Instead
> these
> > tables have a unique index. If I use a TIBOQuery component with the
> KeyLinks
> > property set to the fields of the unique index, IBO will spike the
server
> > for about a half a second every time I post an edit. If I clear the
> KeyLinks
> > and set KeyLinksAutoDefine to True, the KeyLinks property gets defined
as
> > RDB$DB_KEY and everything appears to work much better This does not
happen
> > with all tables that do not have a primary key and I am wondering if
> someone
> > could tell me why this is happening ? Is there anything special that
needs
> > to be taken into consideration when using the KeyLinks property against
> > tables that do not have a primary key ?
> >
> > Thanks in advance,
> >
> > Chris Landowski
> > Dynamic Software Solutions
> >
> >
> >
> >
>
>