Subject | KeyLinks & Primary Keys |
---|---|
Author | Chris Landowski |
Post date | 2001-01-18T13:34:03Z |
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
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