Indicates the maximum number of records in the data file used to manage the automatic reindexing.
As long as this number is not reached, the HFSQL engine starts the automatic reindexing if an index error occurs.
Reminder: No automatic reindexing is available for the data files in Hyper File 5.5 format.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Value of H.AutoIndexingLimit
- The H.AutoIndexingLimit variable is set to 100.000 by default.
- If H.AutoIndexingLimit is set to 0, the automatic reindexing is disabled.
- If H.AutoIndexingLimit is initialized with a negative value, the value of this variable will automatically correspond to the default value.
Caution: If a lock error occurs during the reindex operation (when the data file or a record found in the data file is locked in read/write for example), the automatic re-indexing is stopped and a fatal error (corrupted index) is displayed. Then, you will have to reindex the data file.