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.
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 |