Changing the Default Performance Settings

The support of heavy queries has been enhanced in - R2021x FD05 (FP.2108) by changing the default values of several parameters in the underlying Business Analytics Server Search Logic.

To provide better response times to queries, the default values applied to the Business Analytics Server Search Logic were the following:

  • maxHitsPerSlice ="100000"
  • maxBytesToProcess = "8192"
  • maxSentenceSegments ="3"
  • patternMaxMatches = "20000"
  • Turn off Query expansion spellcheck

Important: For On Premises installations, use the following procedure if you need to change the default performance settings (not recommended).

See Also
About the Index Configuration File
Indexing Options
Reference Information: MQL Indexing Commands
  1. Edit the config.xml file to add the following lines: 

    <PERF maxHitsPerSlice = "<Integer>" maxBytesToProcess = "<Integer>" 
maxSentenceSegments = "<Integer>"  enabled = "<Boolean>"/>
          
<SEARCH patternMaxMatches = "<Integer>"/>

    Where:

    Attribute Description
    maxHitsPerSlice Maximum number of hits that a single index slice can fetch.
    maxBytesToProcess Maximum number of bytes to process in the input text. The remaining bytes are not taken into account for the value selection operation. (0=deactivated)
    maxSentenceSegments Maximum number of sentence segments in the snippet (text summary).
    patternMaxMatches Max number of matches for the patterns under this prefix handler.

    When the maxHitsPerSlice value is reached, an error message appears on the UI.

  2. Using MQL, apply the config.xml file to your database by running: 

    set system searchindex file CONFIGFILE_PATH_AND_NAME ;

    Where CONFIGFILE_PATH_AND_NAME is the path and file name of the config.xml file used by the indexing process.

    For more information, see Applying configuration.

  3. Using MQL, run a baseline indexing to reindex all objects: 

    start searchindex mode FULL ;

    For more information, see Running Indexing.