cancel
Showing results for 
Search instead for 
Did you mean: 

Get error when updating Category has a large number of products

0 Kudos

Get error when updating Category has a large number of products

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. 2016-11-03_11-04-12
6 Comments
apiuser
New Member
Status changed to: Investigating
 
apiuser
New Member

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:

apiuser
New Member

Comment from eric128, posted on GitHub Nov 03, 2016

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

apiuser
New Member

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
New Member

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
M1 Certified

Hi there,

 

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

 

Cheers Sam