Performance Issue: Slow Load Time for Large LOVs

Yes, this performance issue occurs because the default behavior queries all values. You must enable the ‘Filter Before Display’ setting in the LOV definition.

When checked, ‘Filter Before Display’ prompts the user to enter a partial value *before* the LOV attempts to display, forcing the form to query only a restricted dataset, thereby avoiding the slow initial load time.

You can modify this setting via Tools > LOVs, where the LOV is defined, or if it is a custom LOV, within the parameter definition itself.