search

magento / magento2

Prior to making any Submission(s), you must sign an Adobe Contributor License Agreement, available here at: https://opensource.adobe.com/cla.html. All Submissions you make to Adobe Inc. and its affiliates, assigns and subsidiaries (collectively “Adobe”) are subject to the terms of the Adobe Contributor License Agreement.
http://www.magento.com
Open Software License 3.0
11.56k stars 9.32k forks source link

Bulk Uploading & Website gets slow #9056

Closed w130pmpo closed 6 years ago

w130pmpo commented 7 years ago

Preconditions

  1. Magento version 2.1.3
  2. Php 7.0.13-1 Apache2

Steps to reproduce

  1. Creating or updating Bulk Products from CLI using php script

Expected result

  1. Normal speed as long as cache reside

Actual result

  1. Whenever product->save() toggled, loading pages where list products (Category, Page that includes Product Widget) get slow. (Currently around 200K products are stored)

Note,

--- When This Script is not running

  1. If there is no cache, it takes around 15-20 sec to load entire these page.
  2. If there is cache, it takes around 2-3 sec to load entire these page.

-- When This Script is running

  1. Even though there is cache, it takes around 15-20 sec to load entire these page after product->save() toggled.

Any Idea?

magento-engcom-team commented 6 years ago

@w130pmpo, thank you for your report. The issue is already fixed in 2.2.0