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
New Member
Status changed to: Investigating
 
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:

New Member

Comment from eric128, posted on GitHub Nov 03, 2016

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

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.

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.

M1 Certified

Hi there,

 

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

 

Cheers Sam