Troubleshooting: Long delta indexing times due to growing CACHEIVL entries
Delta indexing takes longer than expected due to many entries in the CACHEIVL table.
Problem
Performing a delta index might result in long waiting times, as the CACHEIVL table continually grows larger with entries.
Solution
To resolve this issue,
- Open your custom wc-component.xml file for editing. For more information, see Changing properties in the component configuration file (wc-component.xml) (WC EAR).
- Locate the following snippet:
<_config:property name="CacheInvalidationForCatalogEntry" value="ProductDisplay:productId:$catEntryId$,CategoryDisplay:storeId:categoryId:$storeId$:$catGroupId$" />
- Replace it with the following snippet:
<_config:property name="CacheInvalidationForCatalogEntry" value="ProductDisplay:productId:$catEntryId$" />
- Save your changes and close the file.
- Deploy the customized file to the production environment.