CDB performance optimisation.
Keyword: fuzzy-max-distance="1" max-bitap-errors="1"
Short description of the following content
From release 5.3.2 and 5.4 onwards we optimized index search fuzzy parameters to avoid high memory consumption and improve performance. Here you will find what we have changed and how you can change it on your system.
Those parameters should be set for all features named censhare:text.... except for the quick search feature censhare:text.meta as this feature has a virtual fulltext configuration and no "real" fulltext index configuration like the others.
Release note
Opt: #2724376/C4-41026 Change fuzzy search default to 1 Symptom: Fuzzy search parameter fuzzy-max-distance should be set to 1 Cause: The default value of 2 causes too many results and reduces query performance Solution: Set the default values of fuzzy-max-distance and max-bitap-errors to 1. Note: The values are changed in the default settings in insert-data.xml only to avoid unexpected changes in search behavior at existing installations. It is recommended to change these settings in existing projects.
Versions 4.x
In versions 4.x, the parameters for full text index fuzzy search are part of the embedded database configuration. Look at the screen below how to change it. After the change you have the do a configuration refresh. It is no cdb rebuild or server restart necessary.
Versions 5.1.x, 5.2.x, 5.3.0 and 5.3.1 and higher
In versions 5.x, the parameters for full text index fuzzy search are part of the feature. The default index settings of the features are read only. But it is possible to create a custom configuration with the little "+" button at the end of the dialog. This might even be a custom setting for a specific server. The possible configuration settings here are not new to censhare 5, they have just moved from the embedded database service configuration dialog to the feature definition. The intention was to keep all configuration concerning a feature definition in one place. Look at the screens below how create a customer configuration. There is no further action needed. It is no CDB rebuild or server restart necessary.
1. Open the default configuration:
2. Setup a customer configuration: Use the same settings as in the default setting, except both marked.
Do this for all censhare:text... features except for censhare:text.meta.
