Product Information > Version 7.1 Release Information > Upgrading to JADE Release 7.1 > IndexLoadFactor Parameter in the [PersistentDb] Section (PAR 64067)

IndexLoadFactor Parameter in the [PersistentDb] Section (PAR 64067)

The [PersistentDb] section of the JADE initialization file now contains the IndexLoadFactor parameter, which specifies the percentage of entries that are retained when an index block becomes full and is split. A value of 95 means that 95 percent of entries are retained in the current block and 5 percent of entries are moved to a new block.

Statistically, a 66 percent load factor (the default value) provides optimal loading when entries are added in random key order and a higher load factor (for example, 95 percent) provides better loading when entries are added in sequential key order.

The minimum parameter value is 50, and the maximum parameter value is 95.