IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 number

    JR46363

  • Reported component name

    WC BUS EDITION

  • Reported component ID

    5724I3800

  • Reported release

    700

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-04-16

  • Closed date

    2013-11-29

  • Last modified date

    2013-11-29

  • 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

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSYSYL","label":"WebSphere Commerce Enterprise"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
29 November 2013