2

We have an eCommerce platform. The issue is that when we increased the products to ~3000, the EAV:load_collection is taking a lot of time(~20 sec) and eventually slowing the site. If I remove the products from the database, the site loads faster. Any inputs on reducing the time taken by EAV:load_collection would be highly appreciated

Improve this question
3
  • have you enable flat option from admin.?
    – Anas Mansuri
    Sep 5, 2019 at 6:04
  • 1
    Yes we have enable flat option for category as well as products configuration in setting
    – Baljit Magento 2
    Sep 5, 2019 at 6:17
  • Additional MySQL instance information request. Post on pastebin.com and share the links. RAM size, # cores of your MySQL Host server Text results of: B) SHOW GLOBAL STATUS; after minimum 24 hours UPTIME C) SHOW GLOBAL VARIABLES; D) SHOW FULL PROCESSLIST; E) complete MySQLTuner report AND Optional very helpful information, if available includes - htop OR top OR mytop for most active apps, ulimit -a for a linux/unix list of limits, iostat -xm 5 3 for IOPS by device and core/cpu count, for server workload tuning analysis to provide suggestions.
    – Wilson Hauck
    Sep 19, 2019 at 20:21

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.