JR47295: CMVC 229684 229718 -Search performance enhancements bundle

7.0.0-WS-WCServer-FP009
JR47295 - WebSphere Commerce Search cumulative Interim Fix in V7.0 Fix Pack 6
WebSphere Commerce Version 7.0.0.8 Fix Pack
WebSphere Commerce Version 7.0.0.9 Fix Pack
JR49616 - Performance issue with DynacacheInvalidation Job after applying certain Fix Pack 7 APARs

APAR status

• Closed as program error.

Error description

• This fix is to includes a number of performance fixes for facet
  management
  

Local fix

Problem summary

• USERS AFFECTED:
  V7 FEP5/FEP6 users using search
  
  PROBLEM ABSTRACT:
  Search performance enhancements bundle
  
  
  BUSINESS IMPACT:
  performance enhancements
  
  RECOMMENDATION:
  

Problem conclusion

• Improvements include:
  
  Facet optimzation:
  1. Query out the facets belong to the category and put them into
  cache to remove the solr query to get the facets.
  2. Put fetching image and sequence for each facet into cache to
  avoid unnecessary request for multi-users that click the same
  category for getting facts.
  3. Fetch the facet fields in srchattr and srchattrprop table
  that belong to the relevant store, not all of the facets.
  4. Remove SolrSearchFacetConditionExpressionProvider from
  IBM_ComposeFacetListByCategoryIdand
  IBM_ComposeProductListByCategory profiles to prevent duplicate
  query for facets.
  5. Remove the getColumnType method for saving db calling in
  SolrExpressionProcessor.
  
  Entitlement optimization:
  1. Port data cache to cache the generated entitlement
  expression.
  2. To skip solr call when the generated entitlement expression
  is to APPLY_TO_ALL_PRODUCTS
  
  Payload reduction:
  Do not put empty CatalogGroupView into response noun
  
  -------------------------------------------------------------
  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