JR46363: CMVC 227184 - Leading wildcard searches causing performance issues in the storefront

APAR status

• Closed as program error.

Error description

• The search indexes are not optimized for leading wildcard
  searches. That is, a search term with a preceding wildcard
  character '*' (for example *shoe) might take longer than typical
   wildcard searches.
  

Local fix

• If you want to keep leading wildcard searches, to improve
  leading wildcard search time, add the
  ReversedWildcardFilterFactory to your field types in the
  schema.xml file. Refer to the following documentation on the
  ReversedWildcardFilterFactory:
  
   http://wiki.apache.org/solr/AnalyzersTokenizersTokenFilters#sol
  r.ReversedWildcardFilterFactory
  

Problem summary

• USERS AFFECTED:
   WebSphere Commerce Version 7 Feature Pack 5 users using
  WebSphere Commerce search
  
   PROBLEM ABSTRACT:
   Leading wildcard searches causing performance issues in the
  storefront
  
   BUSINESS IMPACT:
   Potential performance issues in the storefront.
  
   RECOMMENDATION:
  

Problem conclusion

• A new configuration parameter has been added to the
  wc-component.xml file, IgnoreLeadingPatterns, which can be used
  to ignore leading wildcard searches. For example, this parameter
   can be configured as follows:
  
          <_config:property name="IgnoreLeadingPatterns"
  value="[*?]+"/>
  
   -------------------------------------------------------------
   The latest available maintenance information can be obtained
  from the Recommended Fixes for WebSphere Commerce technote:
   http://www.ibm.com/support/docview.wss?rs=3046&uid=swg21261296
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  WC BUS EDITION

• Fixed component ID

  5724I3800

Applicable component levels

• R700 PSY

     UP