DBKeyScope property |
Applies to
TIB_Connection
Declaration
Property DBKeyScope : TIB_DPBFlag;
Description
This property is used to determine how the DB_KEY scope should be treated
for the database connection.
By default, a DB_KEY is only valid for and during a single transaction but it
is possible to be able to obtain a DB_KEY and have it remain a valid (in
scope) reference to a record by setting this property to true.
Caution should be used when setting this to tru because InterBase internally
holds open a transaction for the duration of the connection which will cause
the server to be unable to advance the OAT (oldest active transaction). This
can lead to an eventual server crash and serious performance degredation. If
you use this setting please be sure to cycle connections periodically. I'm
not sure how much this matters in low volume update systems but it would be
mandatory to avoid these problems in a high volume system.