Advantage TDataSet Descendant
Provides caching of open tables.
property NumCachedTables: ShortInteger;
Advantage allows table closes to be cached in order for subsequent opens to occur more quickly. Setting NumCachedTables to a value greater than zero results in the table appearing closed to an application, but still open on the Advantage server. A subsequent open call will return very quickly because the server already has the table open. However, if the access rights for a table are different than those it was originally opened with, the Advantage Client Engine will close the table and reopen it with the changed access rights.
Set this property to a value greater than zero if an application performs many opens and closes on the same table. If an application opens tables and leaves them open, this function provides no additional value.
TAdsSettings.NumCachedTables is a global setting that affects the behavior of the entire application. The default number of open tables that are cached is 0.