IBM Support

JR53403: Improve facet query response time on search indexes that have a large number of index fields

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When faceting against a search index with many index fields (for
example, over 10000 dynamic columns), faceting queries can cause
abnormally high CPU usage. Eventually this can cause the CPU to
max out when there are multiple shoppers browsing concurrently.

Local fix

  • 



Problem summary


    

  • USERS AFFECTED:
WebSphere Commerce V7 Feature Pack 7 and Feature Pack 8.

PROBLEM ABSTRACT:
Improve facet query response time on search index with large
number of index fields.

BUSINESS IMPACT:
Slow response when browsing the store.

    



Problem conclusion


    

  • Only applicable facets to the given category and its
subcategories (in a case of deep search) are returned. In
addition, the SlowCompositeReaderWrapper from the Lucene runtime
is also updated to improve its cache efficiency.

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    JR53403
    • 

  • 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
    2015-05-19
    • 

  • Closed date
    2015-06-23
    • 

  • Last modified date
    2015-07-08
    • 





    

  • 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"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Line of Business":{"code":"LOB31","label":"WCE Watson Marketing and Commerce"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            11 December 2021
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback