|
|
|
A server configuration keyword is available to set the number of tables to keep open per c-treeACE SQL connection, although the table is not in current use. This improves performance in some cases by avoiding the I/O and caching overhead of opening and closing files.
SQL_KEEP_OPEN_TABLES <number of tables>
The default is 60. Specifying a negative value will enable the default.
