Category admin page loading extremely slow with huge category & product data

[vanimilk]

Our Magento 2 website running with 4 different websites and having approximately ~70.000 products for each website, with approximately ~40000 categories between websites.

I have just migrated the site from Magento 1 Enterprise to Magento 2 Commerce, the admin category page is working OK on M.1 although it was quite slow.

But in M.2 it nearly freezes on local setup and only accessible after 3-5 mins of loading, and totally can not be accessed on the production server (hosted on AWS).

I have tried to set max_input_time for PHP configuration to 180000 but it helps nothing.

Did anyone have a solution for this case?

Very appreciated to discuss and break down this one  

[Bhanu Periwal]

Hi @vanimilk 

There are multiple resources available to improve Magento 2 performance and all of them are pretty well documented.

Mode: Magento 2 has introduced modes, being the default one the slowest. Give the developer mode a try and always run your live store in production mode.

php bin/magento deploy:mode:set production

Cache:

Varnish is supported out of the box, pretty easy to configure and use.
Reference url : https://devdocs.magento.com/guides/v2.3/config-guide/varnish/config-varnish.html

Redis: Redis is an optional backend cache solution to replace Zend_Cache_Backend_File, which is used in Magento 2 by default. It can be used for session storage and page caching.
Reference url : https://devdocs.magento.com/guides/v2.3/config-guide/redis/config-redis.html

Memcache: Memcached is an in-memory key-value store for small chunks of arbitrary data (strings, objects) from results of database calls, API calls, or page rendering. In Magento 2 it can be used for sessions.
Reference url: https://devdocs.magento.com/guides/v2.3/config-guide/memcache/memcache_magento.html

Also enable flat tables :

1. On the Admin Panel, Stores > Settings > Configurations.
2. On the left panel, under Catalog, select Catalog.
3. Open the Storefront section,
4. Choose Yes in the Use Flat Catalog Category field.
5. Choose Yes in the Use Flat Catalog Product field.

Reindex by below command:

php bin/magento indexer:reindex

It may help you to boost your website speed!
Problem Solved? Please click on 'Kudos' & Accept as Solution!