Clear all category links for product that belongs to thousands of categories

Questions
1

Hi,

We have products that belong to thousands of categories. Sometimes, for some products, we need to clear all categories from these products.

Normally, I would use CategoryService.GetByBaseProduct() to get all related categories, but this takes way too long for our case (in production it takes over 100 seconds). Using DataService and filter with ContainsBaseProduct also takes some time.

Any ideas?

Litium version: 8.3.1

2

If it’s only one timer then run a script on the DB instead.

3

Unfortunately it’s in the article integration.

4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.