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
>
>
>
>