Start/notes.ini Parameters/FT_FLY_INDEX_OFF

FT_FLY_INDEX_OFF

Parameter: FT_FLY_INDEX_OFF
Short description: Disables automatic on-the-fly full-text indexing during FT searches on non-indexed databases.

Profile

Parameter
FT_FLY_INDEX_OFF
Category
Performance / Memory
Component
Server
Available since
9.0.1 (older)
Supported versions
9.0.1, 10.0, 11.0, 12.0, 14.0, 14.5, 14.5.1
GUI equivalent
notes.ini only (no GUI)
Possible values
0 (default, on-the-fly indexing allowed) / 1 (disabled)

Description

By default, Domino creates a temporary on-the-fly index during a full-text search on a database that is not full-text indexed. This is extremely expensive on large NSF files and leads to peak load (CPU, I/O), especially when LotusScript or Java agents call FTSearch/FTSearchRange on non-indexed databases.
With FT_FLY_INDEX_OFF=1, this on-the-fly indexing is disabled at server level. Requests that require a full-text index then fail with the message „Warning: Agent is performing full text operations on database 'xxxxx.nsf' which is not full text indexed. This is extremely inefficient.“ or fall back to a significantly slower linear search.
The parameter is a classic tuning switch for servers whose load is getting out of hand due to non-indexed FT searches. Before enabling, check which databases/agents would be affected so that the databases can subsequently be specifically equipped with a regular FT index.

Example configuration

Default (parameter not set or 0) – on-the-fly indexing active:
FT_FLY_INDEX_OFF=0
Recommended tuning variant (on-the-fly indexing disabled):
FT_FLY_INDEX_OFF=1
Runtime variant via the server console:
set config FT_FLY_INDEX_OFF=1

Notes & pitfalls

  • Only effective on servers – the parameter has no meaning on clients.
  • After activation, tools and reports that require an FT index without the database being indexed will fail (e.g. mail tracking reports require an index in certain configurations – see HCL KB0078549).
  • Before enabling: identify affected databases (search log file for „extremely inefficient“) and specifically equip them with FT index.
  • Change takes effect immediately after set config FT_FLY_INDEX_OFF=1; a server restart is not necessary.
  • Has no effect on already existing FT indexes or the Updall task.

Sources (HCL Product Documentation)