Get error when updating Category has a large number of products

[apiuser]

Feature request from eric128, posted on GitHub Nov 02, 2016

Preconditions

1. Magento 2.1.2, PHP 7.0.8, Mysql 5.7
2. Ubuntu Apache

Steps to reproduce

1. Create new category (A) with Anchor = Yes, then create some sub categories below it.
2. Add a large of products to A and sub categories. In my case, the total count number of A more than 10000 products.

Expected result

1. Category can be updated without error

Actual result

1. Change category description and hit Save button
2. It takes to long to process (more than 10 min) and get memory error.

[apiuser]

Comment from rganin, posted on GitHub Nov 03, 2016

Thank you for reporting. Seems like an indexing performance issue. It is highly recommended to use 'Update On Schedule' indexer mode for large catalogs, try to switch it to defer indexing process and reproduce again. Links to documentation:

• http://devdocs.magento.com/guides/v2.1/config-guide/cli/config-cli-subcommands-index.html
• http://devdocs.magento.com/guides/v2.0/config-guide/cli/config-cli-subcommands-cron.html

[apiuser]

Comment from eric128, posted on GitHub Nov 03, 2016

Still same result. This time it took me more than 20 min.

[apiuser]

Comment from rganin, posted on GitHub Nov 03, 2016

Thank you for clarification. The performance issue is in URLRewrite area, internal ticket created: MAGETWO-52305.

[apiuser]

Comment from choukalos, posted on GitHub Nov 04, 2016

We don't index this right now but sounds like we should be. Assigning this to myself to see how this lines up with some of the performance and performance issues that are in flight now.

[samir_arora]

Hi there,

we are facing the same issue. do you have any suggesstions for this?

Cheers Sam