Tech Tip: New indexing mode in 4D version 6.5
PRODUCT: 4D | VERSION: 6.5 | PLATFORM: Mac & Win
Published On: February 11, 2000
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.
Mode | Advantages | Disadvantages |
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 |
Traditional | - Consume less memory - The modification of the table is - possible when using this index | - Slower construction - No optimization |