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:
- Open the
workspace_dir\WC\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 HCL Commerce updates. Ensure that you track any changes that are made to the file, so that you can reapply them after HCL Commerce updates.
- 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. - Save your changes and close the file.