Troubleshooting user and organization search performance

Accessing My Account in the storefront might result in timeouts if the site contains many organizations and uses member groups.

Problem

The member group query might be too complex and time out if the site contains many organizations and uses member groups. For example, if there are more than 50,000 organizations.

Solution

To resolve this issue, the following workaround improves performance by simplifying the member group query:
  1. Open the WC_installdir/xml/tools/buyerconsole/MemberSearch.xml file for editing.
    Important: The MemberSearch.xml file is not extendable. That is, any changes that are made to the file are overwritten when WebSphere Commerce updates. Ensure that you track any changes that are made to the file, so that you can reapply them after WebSphere Commerce updates.
  2. Comment out both occurrences of the following snippet:
    
    <subQuery number="2" >
       <role name="Seller Administrator" />
       <role name="Customer Service Representative" />
    	  <role name="Customer Service Supervisor" />
    </subQuery>
    

    The snippet appears within the <organizationSearch> and <userSearch> sections of the file.

  3. Save your changes and close the file.
  4. Restart the WebSphere Commerce server.