Search Elements to Avoid

The following list includes import elements known to degrade system performance. This list can be used to troubleshoot existing imports, and can also be reviewed prior to creating new imports to prevent performance problems.

For general information on searches, see the Search topic in the Getting Started / User Guide documentation here.

Avoid Full Text Indexable

The 'Full Text Indexable' setting on attributes allows for searching for individual words in the text value of an attribute. This option can be considered when searching for words, or set of words, in attribute values. However, applying full text indexes on one or more attributes has a system-wide negative impact on performance because it is much more expensive to read, write and query such values.

For more information, see the Full Text Indexable Attributes topic in the System Setup / Super User Guide documentation here.

Avoid Inherited Values and Regular Expressions

Advanced searches in the workbench and Web UI should avoid the following options to achieve the recommended performance:

• 'Include Inherited Values' - only use when required.
• 'Regular Expression' - disables database indexing, only use when required.

Avoid Root Hierarchies in Search Below

The 'Search Below' option should be used with caution and only when necessary to achieve the required result. Specifying many root nodes in Web UI searches is specifically not recommended.

For example, use a granular hierarchy node instead of searching the full primary product hierarchy.