Feature Pack 7 or later

Troubleshooting: Displaying only child category facets of a browsed category

Displaying only child category facets of a browsed category helps limit the number of SQL queries for catalogs with a large number of categories.

Problem

Displaying only child category facets of a browsed category helps limit the number of SQL queries for catalogs with a large number of categories. Otherwise, there is a performance hit for browsing child categories within a category.

If the MAX_DISPLAY column in the FACET value is set too low, some categories might not work correctly.

Solution

To resolve this issue:
  1. Set the MAX_DISPLAY column for SRCHATTR_ID=-1013 in the FACET table to -1.
  2. Set the displayChildCategoriesOnly property to true in your custom wc-component.xml file. For more information, see Changing properties in the component configuration file (wc-component.xml) (Search EAR).

These settings ensure that only child category facets of the browsed category are displayed, and that the subcategories of the child categories are not faceted.