Starting with version 6.5, 4D allows you to now choose between two index modes: the "traditional" mode, which is the mode used in previous versions of 4D, and the new "fast" mode, which in most cases allows for a significant increase in speed.
If you choose the fast mode, you will be allowed to indicate the usage type for which you want the index to be most efficient: When adding or inserting records or when performing queries.
|Fast||- Speed of construction|
- Possible parameter setting
- according to the use
|- Consumption of more|
- significant memory<
- Access to tables is blocked
- when using this index
- Consume less memory
- The modification of the table is
- possible when using this index
- Slower construction
- No optimization